Leading zero

F

Firefli

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

Duke Carey

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
 
Top