Depends on whether the VALUE has to ahve a leading zero, or just the DISPLAY.
If the VALUE must have a leading zero, use Ray's suggestion.
If it's just the display, use a custom format (Format->Cells->Number->Custom)
like "000000" which will show the value
123 as 000123
and the number
1234567 as 1234567
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.