View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brandy Brandy is offline
external usenet poster
 
Posts: 52
Default Excel Leading Zeros

How can I customize a cell that will allow me to enter 2 leading zeros?
I.E.
I am trying to Format the cell to have a total of 9 digits. The first 3 MUST
be 100 and the rest of the 6, I just type in. However I MUST be able to enter
the number starting with 2 zeros. HELP!