Forum Discussion
VSMich
Oct 28, 2022Copper Contributor
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...
Riny_van_Eekelen
Oct 29, 2022Platinum Contributor
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.