Excel Leading Zeros

[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!

 

[Guest]

Right click on a cell and choose Format Cells
Then in the category select Text
This will allow zero's

 

[Guest]

Format Cells, Custom and in the type box enter:

10000####

HTH

 

[Guest]

Thanks so much! That worked!

Format Cells, Custom and in the type box enter:

10000####

HTH