Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change direction of Enter Key in EXCEL 2007 | Excel Worksheet Functions | |||
In Excel why does the date I enter automatically change by 1 day? | Excel Worksheet Functions | |||
why don't my totals change when I enter additional data? | Excel Worksheet Functions | |||
how do i enter a formula in excel that will change a cell value | Excel Worksheet Functions | |||
Enter 1 in a cell, excel change to 0.001, WHY? | Excel Worksheet Functions |