this post was submitted on 08 Aug 2026
1 points (100.0% liked)

LibreOffice

819 readers
1 users here now

LibreOffice is a powerful free and open source office suite, used by millions around the world.

founded 3 years ago
MODERATORS
erAck@discuss.tchncs.de
1
How do you get the first "0" in "050" to show in a cell? (programming.dev)
submitted 6 days ago* (last edited 6 days ago) by Flagstaff@programming.dev to c/libreoffice@discuss.tchncs.de
2 comments fedilink hide all child comments
 

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
[–] Flagstaff@programming.dev 0 points 2 days 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)...