Forum Discussion
MicrosoftControl data conversions in Excel for Windows and Mac
Tony_Williams2335 unfortunately while this option is there, it is ignored and the changes are applied whether these are ticked or not. 😕
Glad to know that I'm not the only one to notice the Automatic Data Conversion settings do nothing at all. I have HATED how Excel converts large numbers to scientific notations for years. When I heard this feature was coming I was excited. But only to find out that this feature does nothing. Still, when I open a file the numbers get converted to Scientific Notation regardless of how this setting is set. Clearly this function does not work. Who the heck decided to do this in the first place. No one wants scientific notation. Not even scientists.
- So true, I opened a topic on Microsoft Forums : https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-enable-automatic-data-conversions-settings/b8aa90ef-11b6-4860-87a2-0fe203f0c43d
Please say something here to make them open an issue and make it solved.- Done!
Annoyingly this does do things but ONLY for numbers over 15 characters. if you have less than 15 characters it will still get E+ on it. This function just needs removing completely. If i want to convert a column into scientific notation, guess what microsoft? i can right click and choose formatting and then pick SCIENTIFIC NOTATION, and like Lexmark, i feel it will never be chosen.
