Cell Number format

L

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
 
L

Lamb Chop

Thanks, bigwheel

It works like a charm.

In general, what is the different between a "#" and and "0"?

I though 0# is that # is the number, e.g. 1, 2, 3 including "0".

Thanks

Man
 
B

Bob Phillips

# means print that digit if it is present, else ignore it, 0 means print it
if present, a zero if not.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top