How to Disable automatic conversions to Scientific format in Excel

Copper Contributor
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 retrieving them (like to personal numbers used in Sweden or telephone numbers or any other longer numerical code). How were you thinking, Microsoft? Can I disable that generally in my Excel program so that doesn't happen automatically when in Excel opening documents from other programs?
1 Reply

@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.

https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce...