18
How do you get the first "0" in "050" to show in a cell? (programming.dev)
submitted 3 weeks ago* by to c/libreoffice@discuss.tchncs.de
9 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
[–] 5 points 3 weeks ago

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.

  • permalink
  • fedilink
  • source
    •