View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bigwheel bigwheel is offline
external usenet poster
 
Posts: 222
Default Cell Number format

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