ExcelBanter - Excel Leading Zeros

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Leading Zeros (https://www.excelbanter.com/excel-discussion-misc-queries/159962-excel-leading-zeros.html)

Brandy

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!

Mike

Excel Leading Zeros

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

"Brandy" wrote:

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!

Jim May

Excel Leading Zeros

Format Cells, Custom and in the type box enter:

10000####

HTH

"Brandy" wrote:

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!

Brandy

Excel Leading Zeros

Thanks so much! That worked!

"Jim May" wrote:

Format Cells, Custom and in the type box enter:

10000####

HTH

"Brandy" wrote:

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!

All times are GMT +1. The time now is 12:27 AM.