If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2002 and 2000 co-install. Control Which Starts ? | cnuk | General Discussion | 2 | January 17th, 2005 08:07 PM |
Problems using Excel 97 worksheet in Excel 2002 | plfoley | Worksheet Functions | 1 | May 2nd, 2004 09:54 AM |
Excel 2000 vs Excel 2002 | Harald Staff | Worksheet Functions | 1 | April 16th, 2004 11:14 AM |
Excel 2002 Page Setup created in Excel 98 | Maia | Worksheet Functions | 0 | March 9th, 2004 12:46 AM |
Excel 97 to Excel 2002 | Dean | Setting up and Configuration | 4 | October 17th, 2003 05:08 PM |