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

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

Guest

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.
 
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)
 
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...
 
Back
Top