Forum Discussion
How to Disable automatic conversions to Scientific format in Excel
On open Excel converts documents previously exported to CSV from other sources and makes them unreadable, due to this automatic conversion of numbers to Scientific format and there is no way of retrie...
VSMich You should not open CSV files by just double-clicking on them. Then Excel does some goes work based on the data it finds. And, as you discovered that's not always what you want.
Import the CSV into Excel in stead. More about that in the link below.