Even "Number Format: General" still omits the starting 0. I can't even get it to show up if I lead with a space or a "-." What is the trick? This is super-annoying.

you are viewing a single comment's thread
view the rest of the comments
[–] 1 point 3 weeks ago (1 child)

people already explained the options but just want to mention I just do the string thing. The only time I come across the need is for id type numbers and usually am not going to do any math on it. in that case i makes sense to treat it as a string.

  • source
  • hideshow 2 child comments
  • [–] [S] 1 point 2 weeks ago

    Right, same; this is part of an ID and is needed. I'm not at a computer right now to check but I'll look for it some more, thanks to the other commentators' guidance here (I had posted here because I couldn't find it)...

  • source
  • parent