How to prevent decimals from converting to dates when opening a .csv file in Excel.
Import a .csv list directly to Excel by using the Import .csv -file feature. Following these steps, you can prevent Excel's unwanted automatic data conversion.
1. Open an empty spreadsheet, and click Import -> From CSV file.
2. Select "Delimiter". If the company names include Scandinavian letters(åäö, etc.) change the File Origin to Windows(ANSI).
3. Change Delimiter to Semicolon - This separates the text into individual columns
4. The most important thing when trying to prevent the decimal conversion to dates. Open Advanced →Decimal separator and change comma(,) to dot(.).
Now save and click Finish. The information should now be visually corrected.