Control data conversions in Excel for Windows and Mac

Lies. Doesn't work still a year later. If we want "Scientific Notation" we will pick "Scientific Notation" instead of Text/Number. STOP DOING THIS!

Even though I have all the automatic data conversion settings turned off, Excel is STILL CONVERTING!!!!  The unwanted data conversion is costing me and all of the team members in my company a lot of money in wasted time manually fixing the unwanted conversions.  I cannot just apply a formula in another cell to resolve these problems, and it must be done manually.  It takes a tremendous amount of time to fix the data.  And clearly many other users in the world are having the same problem.  This needs to be a priority for Microsoft to fix.  How can we get Microsoft to fix this problem ASAP?

As others have noted these settings simply do not work. Even after disabling them Excel still automatically converts various strings into dates when opening CSV files and loses data in the process. The auto-conversion notification setting also does nothing. Has anyone at Microsoft actually tested this functionality in the past 3 years?

Chirag_Fifadra​ 

The feature doesn't work at all.  Excel is still converting and corrupting CSV data even with these check boxes all disabled. 

This is absurd. A feature that has been requested for years and they finally "address" the issue. THIS DOES NOT WORK.

These settings are currently completely pointless. Absolute idiots behind these stupid decisions and complete lack of support around fixing it clearly.

These new options are great, but one of the great frustrations with Excel is all the automatic changes it does to data and how it's displayed and there are many more ways left that we have no control over. PLEASE let us decide if we want our data mangled or not. The answer to the question "When should Excel display a value in scientific notation" is "Never". Why would I ever want that? Why would I want my data destroyed? I'm begging you to add an option to disable this data corrupting feature.

6 months later this feature still does not work as promised.

Firstly the 'Notify me of automatic conversation' doesn't ever fired off.

When opening a CSV file with phone numbers formatted as whole numbers, they all turn into E+11 numbers, despite holding the whole number (as seen in formula bar). Resizing the cells don't remove the scientific notation 

Problem is, most users are aware of nor familiar with this feature, so they can copy and paste data in from their opening of CSV files with the auto conversion happening, and now there's no way of noticing that some mobile numbers are truncated and some not.

By the time this was spotted, we'd already imported the data onto our CRM.

I expect when deselecting the options above, that my cells simply won't display long numbers as E+11 numbers. We straight up just need an option to completely disable Scientific notations (which are rarely used by the average user) so that whole numbers show up as whole numbers (i.e. Custom format > "0") if they've not been 'converted'.

Please remove the feature, to convert numbers into Scientific Notation/Text.  Just keep it as numbers.

We are users who use your software daily and this feature wastes our time.

We get thousands of numbers daily, that we need to copy and paste it into excel(that automatically converts it into Text or Scientific Notation) where we then convert it into numbers again (also ensuring that it isn't converted to text).

I do not understand the point of executing this feature and not have it work like it was promised.

Please update the feature, thanks.

This setting sounded SO promising. The automatic reformatting of text data is often so opposite of helpful. Alas, although I found this setting and unchecked all the boxes, restarted Excel, rebooted my PC, and regenerated the .csv file... the problem persists!  Ugh.