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.
Start with a »'«. Or configure the cell to not be a number, but a string.
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.
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
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.


