Leading zero
 

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.

Leading zero
 

one way;
format cells to text
HTH

"Firefli" wrote:

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.

Leading zero
 

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




"Firefli" wrote:

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.