Auto date conversion

[Aaron Stamboulieh]

I am trying to type the number 1-2130 into an Excel spreadsheet, but it
automatically turns it into Jan-30 every time. I've looked all over for a
way to disable it, does anybody know which option toggles this automatic
correction? It happens in both Excel 2003 and 2007.

Aaron

 

[JE McGimpsey]

Preformat the cell as Text, or put an apostrophe (') as the first
character of your entry to bypass XL's input parser.

There's no toggle, it's just the way the parser operates.

 

[Dave Peterson]

Excel thinks you're typing a date way out in the future.

One way around it is to start with a leading apostrophe: '1-2130

Another way is to preformat the cell as Text and then do the data entry.

 

[Aaron Stamboulieh]

Thanks so much for your help.

Aaron

Excel thinks you're typing a date way out in the future.

One way around it is to start with a leading apostrophe: '1-2130

Another way is to preformat the cell as Text and then do the data entry.