How do I stop Excel 2002 from autoformatting numbers into dates?

[MyHeartPoursOn]

When I type in a number such as "3/8" or "3-8", Excel automatically changes
it to "08-Mar". I've tried changing the format of the cell to general, but
that changes the data to say "38149" and then changes back to custom
formatting when I attempt to type in "3/8" again. I've tried turning off all
autoformatting and autocorrecting. All this technology of "guessing" what
you're trying to type can be extremely frustrating and pointless when you
can't even type basic data into the worksheet.

[Mike]

Change the cells to plain text.

"MyHeartPoursOn" wrote:

> When I type in a number such as "3/8" or "3-8", Excel automatically changes
> it to "08-Mar". I've tried changing the format of the cell to general, but
> that changes the data to say "38149" and then changes back to custom
> formatting when I attempt to type in "3/8" again. I've tried turning off all
> autoformatting and autocorrecting. All this technology of "guessing" what
> you're trying to type can be extremely frustrating and pointless when you
> can't even type basic data into the worksheet.