Forum Discussion
Formatting frustration in excel
I have a code column that contains values like: 250.00 1.280923E+14 452.20 All I want is to the convert the scientific notation values to their full number. I have tried so many different m...
Use of VBA seems like overkill. See the attached workbook for some options.
Of course, remember that the way Excel stores numbers (IEEE floating point, with exceptions) means that you get only about 15 decimal places of precision.