|Subject:||Re: How do I remove the annoying automatic date formatting in Excel?|
|Posted by:||Jim Rech (jrre…@hotmail.com)|
|Date:||Thu, 11 May 2006|
The feature cannot be turned off. Your best bets are using Text format, as
you mentioned, or preceding the entry with an apostrophe.
"Jose-Edinburgh" <Jose-Edinbur…@discussions.microsoft.com> wrote in message
|I use Excel to display/sort tables of data arranged in columns.
| Some of ther columns are numeric, some are text.
| One of the columns is giving me a lot of hassle. It should contain names
| genes, which Excel does okay, until you find names like "SEP7" or "MAR3",
| which Excel transforms into a date form, usually "Sep-07", but sometimes
| a 5-digit number like "39326".
| I have cancelled every auto-correct and auto-format option I can think of,
| but no joy.
| The only thing that works is format the whole thing as text.
| Isn't there a way to avoid this "by default", so that Excel just shuts up
| and takes what I type in as I type it, without changing anything? If it's
| number, it's a number, if not, it's text...
| It's very annoying, because I have these tables with tens of thousands of
| names, which I rearrange, merge, mix... when you import a column of names
| names are changed without warning. I don't want Excel to guess anything
| If you know how to turn off this "feature" that appears loaded by default,
| please let me know.
How do I remove the annoying automatic date formatting in Excel? posted by Jose-Edinburgh on Thu, 11 May 2006