[smeegle]

I am trying to enter a whole number that looks like this "123" into a cell and have it look like this "00123". I've even tried to custom format it and I can't get it to work. Please help

 

[OBP]

Hello smeegle, select the cells that you want to format and the on the main menu select Format>Cells>Number>Custom
and type in the box
00000
this will give you the format that you have shown.

 

[smeegle]

Thanks, OBP, it works. I thought that I had already tried that solution but apparently I hadn't.