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

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.
 
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)
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to show numbers that begin with 0 in excel 2
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
How add a digit to front of number in each cell in excexl column 1
Default number format in Excel 1
Cell format changes when I paste 4
Custom Format on 16 Digit Number 5
"Bug" in number format for long number entries? 7
how do i enter a negative number sequence with spaces in excel 1

Top