Thread: cell format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lamb Chop Lamb Chop is offline
external usenet poster
 
Posts: 38
Default cell format

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