question about zeros

B

brooks

I'm working on a spreadsheet where I'm entering serial numbers... ever
serial # starts with a zero.. I enter it and then when I move on to th
next cell, the zero disappears and I can't for the life of me figur
out how to make it stay there! Anyone help?

Thank you
 
G

Gord Dibben

Brooks

Pre-format the cell(s) as TEXT or start the entry with an apostrophe.

i.e. '01234

These numbers will be entered as text which I assume you need.

Gord Dibben XL2002
 
J

Janet Bridges

-----Original Message-----

I'm working on a spreadsheet where I'm entering serial numbers... every
serial # starts with a zero.. I enter it and then when I move on to the
next cell, the zero disappears and I can't for the life of me figure
out how to make it stay there! Anyone help?

Thank you !

If you are working with Excel you will need to type a
Click to expand...
single quotation mark in front of the number so Excel does
not format them.
------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.
Click to expand...
 
Top