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