Leading zero

[Guest]

How can I reset the default to show a leading zero? At this time I have to
use the apostrophe in order for it to show.

 

[Guest]

one way;
format cells to text
HTH

 

[Guest]

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