how to format cell in excel for 12 digit number starting with a 0

L

lmattox

I can't remember how to format a cell within and Excel spreadsheet to enter
numbers that begin with a "0". I think there is a way, but I can't find it.

Can someone tell me how to format so that my numbers can begin with a 0?
thx.
 
D

Dave Peterson

Preformat the cell as Text and type your entry.
Start your entry with an apostrophe: '001234
Give the cell/range a custom number format: 000000
(format|cells|number tab|custom category -- xl2003 menu system)
 
L

lmattox

Thank you very much! Worked like a charm!!!!

Dave Peterson said:
Preformat the cell as Text and type your entry.
Start your entry with an apostrophe: '001234
Give the cell/range a custom number format: 000000
(format|cells|number tab|custom category -- xl2003 menu system)
Click to expand...
 
Top