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.

top 2 comments
sorted by: hot top controversial new old
[โ€“] HubertManne@piefed.social 0 points 6 days ago (1 children)

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.

[โ€“] 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)...