LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Why does Excel change the data I enter?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change direction of Enter Key in EXCEL 2007 H Gallant Excel Worksheet Functions 2 June 12th 07 11:48 PM
In Excel why does the date I enter automatically change by 1 day? skoag Excel Worksheet Functions 1 May 8th 06 09:48 PM
why don't my totals change when I enter additional data? Melozia Excel Worksheet Functions 2 April 26th 06 07:06 PM
how do i enter a formula in excel that will change a cell value Jace35 Excel Worksheet Functions 4 April 21st 06 03:44 PM
Enter 1 in a cell, excel change to 0.001, WHY? Jag Excel Worksheet Functions 1 February 3rd 06 03:38 PM


All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"