Forum Discussion
Control data conversions in Excel for Windows and Mac
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.
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.