• IllNess@infosec.pub
      link
      fedilink
      English
      arrow-up
      1
      ·
      3 months ago

      You have to set the cell as text rather than a number.

      I wonder if you can format a cell with a custom number type to have leading zeros…

      • snooggums@midwest.social
        link
        fedilink
        English
        arrow-up
        3
        ·
        3 months ago

        Making it text means it is something other than a number, but generally it has already screwed up the leading zeros by the time you have the opportunity to make it text.

        You can set a special format if all the numbers are the same number of characters, but not for something like 0043 and 05467.

        • IllNess@infosec.pub
          link
          fedilink
          English
          arrow-up
          2
          ·
          3 months ago

          Thanks for the info.

          I had the leading zero issue importing a CSV so I couldn’t set the cell type so I see your point.