Why does Excel change the data I enter?
Hi,
I guess I'm correct in saying the autocorrect function in Excel has
irritated you but all is not lost, you can disble the corrections you don't
want.
Tools|Auto correct options
Type NWO in the Replace box and when the correction appears in the With box
delete it.
Despite your obvious annoyance this is a useful feature and it's also global
so any change you make also affects MS Word.
Mike
"Going Postal" wrote:
OK, I am getting really tired of MS Excel changing the data I enter. I do not
want the "help".
Currently, I am trying to enter "NWO" in a cell. But, it always changes to
"NOW".
I didn't notice that MS Excel had "helped" me until I was proofing my
spreadsheet.
I tried inserting an apostrophe before it, it didn't work. ("'NWO" == "NOW")
I tried to put a space before it, it didn't work. (" NWO" == " NOW")
I've known that this "help" also occurs when I try to enter the following
data:
- "32:23" (gets changed to "1/1/1900 8:23:00 AM" )
- "4/5" (gets changed to "4/5/2009" )
- "12-2005" (gets changed to "12/1/2005" )
These, I figured out that if I put an apostrophe before the data, the data
is entered into the cell as I want it. But, I'm getting tired of doing that.
What I want Excel to do is: TO ACCEPT THE DATA I ENTER & NOT CHANGE IT!
I don't care if the programmers in Redmond, WA think I made a mistake.
Thank you, (and sorry for the caps, but after wasting several hours trying
to find a solution in the Help...well let's not go there right now)
|