number format with leading 0

D

Darby

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
 
R

Ron Coderre

Try this:

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


Does that help?

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

SteveG

Darby,

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

Cheers,

Steve
 
D

Darby

Thanks

Ron Coderre said:
Try this:

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


Does that help?

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


Darby said:
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
Click to expand...
Click to expand...
 
Top