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.
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.
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.
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)…