Is there a way to STOP EXCEL from converting data into Scientific Notation?
Microsoft Excel apparently assumes that any data that contains numbers and an E is supposed to be scientific notation and converts it.
17195E000039 automatically changes to 1.7195E+43
17221E000112 automatically changes to 1.7221E+116
Is there a way to prevent Excel from doing this so it doesn't continue to cause problems for all of us users who never want to use SCIENTIFIC NOTATION ever? I cannot foresee any time where I will EVER want to have anything converted to scientific notation. This useless functionality only causes problems.
How do I stop Excel from trying to convert text into scientific without manually performing some operation first?
Unfortunately, the data comes from another system that exports to excel that I cannot change. I cannot manually change the page beforehand and going through afterwards sucks.