View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
No help No help is offline
external usenet poster
 
Posts: 1
Default can't keep 1-1 from becoming Jan-1, it isnt a date

I am really sick of excel turning everything that might look like a date into
one

Please make it easy to figure out how to turn it or every autoformatting
thing off completely until user turns it back on or hits a reset. I spent 2
hours searching all the help on Microsoft only to be told how to change how
the date appeared, when i change the jan-1 back into a "general number" i
dont get 1-1, i get 38594 or something. When I re-enter "1-1" after
supposedly formating it to "general" it turns right back in to a date again.

How do i turn the autocorrecting of scores (1-1) into dates (Jan-1) off???

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc