cell format

[Lamb Chop]

How can I change single digit to two digits number

e.g.
3 to 03

I have used custom cell format by

0#

but it fails if it is 0. It cannot change to 00

Thanks

OS: win2k
Office 2k

 

[Desert Piranha]

How can I change single digit to two digits number

e.g.
3 to 03

I have used custom cell format by

0#

but it fails if it is 0. It cannot change to 00

Thanks

OS: win2k
Office 2kHi Lam Chop,

Have you tried the custom format of
00
or
00;