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.
There’s two options, one is to turn it into a string as discussed.
The other is:
Format a cell with a number format such as \0000. This format can be assigned in the Format code field under the Format - Cells - Numbers tab, and defines the cell display as “always put a zero first and then the integer, having at least three places, and filled with zeros at the left if less than three digits”.
https://help.libreoffice.org/latest/en-US/text/scalc/guide/integer_leading_zero.html
Start with a »'«. Or configure the cell to not be a number, but a string.
Yeah, 050 is a string not a number programing wise.
Change the number format to ‘Text’.
General will attempt to apply the correct format based on cell contents. The numbers are making it implicitly apply the ‘Number’ format to the cell.
Format Cells / Numbers (tab) Category (choose Number) / Format (is General) / Options (Leading Zeros 1)
Do not format numbers as ‘Text’ if you need to use them in formulas of finance like sums.
Did you try putting a ’ at the start of the cell?
Thanks, I do know about that but I want to avoid using an escape char because I want to be able to copy the cell without hidden characters entering the clipboard.
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)…