Excel - How to open and save a Csv file by keeping the date and number format intact ?

About

Changing the localization windows parameters will open and save CSV file correctly in Excel with the good number and date format.

Parameters

Control Panel > Region and Languages > …

Number

The standard field delimiters for CSV files are commas. But on European Windows versions this character is reserved as the Decimal Symbol and the “List Separator” is set by default to the semicolon.

_

Date

_

Reference


Powered by ComboStrap