• 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.