• snooggums@midwest.social
    link
    fedilink
    English
    arrow-up
    3
    ·
    4 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
      link
      fedilink
      English
      arrow-up
      2
      ·
      4 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.