number format with leading 0

[Guest]

Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.

Thanks

 

[Guest]

Try this:

Format>Cells>Number
Category: Custom
Type: 00
Click [OK]


Does that help?

***********
Regards,
Ron

 

[SteveG]

Darby,

Enter the format for your cells in Format-Cells-Number-Custom-Type as
0#

Cheers,

Steve

 

[Guest]

Thanks

Try this:

Format>Cells>Number
Category: Custom
Type: 00
Click [OK]


Does that help?

***********
Regards,
Ron

Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.

Thanks