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

Have you tried a custom cell format of 00 ?

"Lamb Chop" wrote:

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

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





"bigwheel" wrote in message
...
Have you tried a custom cell format of 00 ?

"Lamb Chop" wrote:

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

# 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)

"Lamb Chop" wrote in message
...
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





"bigwheel" wrote in message
...
Have you tried a custom cell format of 00 ?

"Lamb Chop" wrote:

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