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



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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question