Forum Discussion
Unwanted automatic change of text number format to scientific
You will find a setting under Options/Data/Automatic Data Conversion which sets
"Convert digits surrounding the letter "E" to a number in scientific notation"
In response to the old comment
"They need to disable this dumb "feature". I can't imagine a single person on the planet that finds it useful",
It is not a dumb feature because anyone involved with scientific work or engineering is likely to require such notation for almost every number in the workbook. 1.24E+12 is a standard way of representing the number 1237650000000 to 3 significant figures. To ask otherwise is the same as expecting a leading "-" to be treated as a hyphen followed by text. I does happen, but Excel is really about numbers and calculation.
Sir that did not work, i do believe I posted that it didn't work in my comments. I figured it out. It's a dumb feature to have automatically enabled. Everyone that uses Excel is not an Engineer or works with scientific work. Those sort of features should be optional, the user should have to select those options. Not forced on you, then your directions don't work to remove that feature.