Allow us to turn off automatic conversion to date
Search for "make excel stop converting numbers to dates" and you will see the user demand for this feature. Please for the love of all that is holy let this be at least an advanced user setting.
Thanks for the suggestion Jessica. We’ve got a few other suggestions on the site that are similar with scientific notation, etc. We’ll take a look at this area, and pay special attention to any cases that get a lot of votes. So please keep the votes coming to help us do a good job at prioritizing asks like this!
John [MS XL]
Do you guys actually read these complaints?
I'm so sick and tired of my sku numbers changing to dates! People have been complaining about this for YEARS. Please listen
A student's email ID begins with APR so when I import the CSV file with him in it, suddenly his email ID becomes a date. Who in the world thought this was a good idea?
I use excel to analyze large chunks of data. The raw data is usually in the form of a csv file and I am not always aware that some fields may contain data that will be changed to a date and changing the format after the import is not usually helpful as it has already been converted. Some way to turn this off, especially if you open or import a csv file would be ideal. It is the single biggest issue when dealing with data comparisons in Excel. Thank you
John, This is the same problem as "Allow us to turn off automatic conversion to date", please combine
Stop pretending you care, John/Microsoft. This has been a problem for decades and you've refused to fix it.
you'd think when bugs were identified the fix would be implemented immediately rather than for them to be dismissed as a feature request
When an implementation leads to data corruption then it's a bug not a feature
Clay Dreslough commented
Although this thread is only 3 years old, it's actually been MORE THAN 15 YEARS since I originally reported this Microsoft. :(
(And I wasn't the only one complaining about it at the time).
Why hasn't this been fixed? I can't find a way to stop it converting ratios (e.g. 2 / 5) to dates. I've tried converting the column to text ahead of time. This makes excel unusable for what I want to do. It's been 3 years. What are you doing? It would be so simple to just allow us to turn it off, so many people are complaining about it. What is going on?
WHY HAS THIS NOT BEEN FIXED? IT HAS BEEN THREE YEARS
I never thought it's a harmful feature, it's a ******* bug, all right?
Kasperi Korpinen commented
Where can you follow how these things are taken into account in development?
This is an obvious case. With the resources of MS, it should not be a problem to fix this
Either you listen to the users or you don't.
After having a quick look to other development suggestions, they seem to be mostly pretty well formulated and from enlightened users. Is excel made for profits only or for the users and their productivity for the economy as a whole? Maybe MS has leadership issues, like many bigger companies, that would lead to an inability to lead development efficiently?
I work with foot-in measurements, which entered as #-#.
Is there a way I can bill Microsoft for wasting my time by automatically changing all my data?
BTW: resetting the cells to TEXT doesn't appear to fully fix this, so I have to vet multiple hundred entry lists to check this.
I was referred here by MExcel on twitter. Why isn't this an autocorrect option that can be turned on/off? Or maybe let me paste text without autoformating rules being applied.
Jakob Pilgaard Pedersen commented
So many other suggestions for Excel has been accepted, why won't you guys just fix this really basic thing! I want the ability to turn of ALL automatic conversion.
Clay Dreslough commented
PLEASE FIX THIS!!!
Although Excel was originally designed as a spreadsheet, I now use it entirely to view and manipulate large sets of CSV data. However, this bug is an app-killer. I've written so much code to work around this that I now pretty much have my own application that I use as an alternative to Excel. If Excel doesn't fix this before my Office 365 re-ups, I'll just cancel my subscription and use a combination of text editors and my own code.
one irate excel user commented
Please, please remove this idiotic feature. Who was the idiot that thought autocorrecting numbers to dates without any way to disable it would be a good idea? and why hasn't this feature been removed already, or at a minimum gives us an option to turn it off permanently.
in the age of massive data from many sources exporting a CSV form one place or another is so common. and simple values getting auto converted to dates and having business developers make complicated macros or applications to work around this is completely unnecessary. Why can't auto formatting just be a check box in advanced options to TURN OFF?
Caleb McNevin commented
Microsoft: Though number of users who've shown support is a good metric in most cases, this case is not one of them. You're never going to get the thousands of votes on this issue that you get on others due to the fact that biologists and people working in medical research are a minority compared to people in business roles. Please consider the impact of following a single metric, and consider bumping this issue up to a higher priority.
Terence Martin commented
I'd make this request more general: Allow us to turn off ALL automatic formatting. Everything. Don't change my number format, don't change column width, color, size, nothing. Excel almost always guesses wrong, and then I have to waste time undoing several items rather than just setting the format I want.
Don D commented
Please let the user decide what format to assign to a cell, instead assuming *anything* that looks even close to a date needs to be formatted as a date. You have gotten yourselves into more trouble by trying to assume what the user wants, rather than giving the user the ability to make their own choice or specify the preferences they want.