Excel Leading Zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Right click on a cell and choose Format Cells
Then in the category select Text
This will allow zero's
 
Back
Top