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

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.

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

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)

lmattox wrote:

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.

--

Dave Peterson

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

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

"Dave Peterson" wrote:

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)

lmattox wrote:

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.

--

Dave Peterson