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.
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.
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.