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

G

Guest

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

Similar Threads

Excel autoformatting dates 1
numbers to dates 9
How can I stop Excel from autoformatting entries into a date 1
How do I prevent Excel from changing numbers into dates? 3
Formatting Numbers to Text or??!!! 6
How do I stop auto conversion of numbers to a date? 2
Converting numbers stored as dates to text in Excel 1
Formatting Numbers into Text or???!!! 2

Top