How do I COMPLETELY turn off Excel autoformatting?
September 28, 2006 7:20 AM Subscribe
How do I completely turn off all autoformatting in Excel?
posted by EndsOfInvention to Computers & Internet (6 answers total) 1 user marked this as a favorite
Excel's autoformatting is driving me insane. At work I have to enter lots of ranges into Excel, such as "10-50". Excel helpfully thinks I actually mean "1st of October, 1950", and changes the cell to "Oct-50". Of course, changing the cell format away from Date merely changes the cell value to "18537". So not only does Excel automatically change the format away from what you entered, it irreversibly changes the actual data as well
I know that changing the cell format to Text beforehand will stop any autoformatting, but remembering to do this every time I enter data is incredibly frustrating (and I have other autoformatting issues aside from the date one). Is there a way to completely deactivate
The most annoying thing is that if I make a mistake and enter "10-49" into lots of cells instead of "10-50", and then try and correct all the cells with Find & Replace, it changes the cells back to Dates even if I've previously set them all as Text!