Preformat that range (whole column?) as text.
(Format|cells|number tab|Text)

Or start your data entry with an apostrophe:

'.410
'30-06



Kram wrote:

Greetings,

I'm trying to make a spreadsheet of available guns at our store and I need
to type in things like:

.410
.300
.308
.243
30-06

but it self corrects .410 to .41 and if I write 10-11-11 it wants to create
a date.

How do I turn off the formatting so I can type in decimals and hyphens
without excel correcting them to some other format?

Thanks, Mark

--

Dave Peterson