CSV to excel conversion date format getting changed

(1) Share

Report

Posted on by ManishNair56

While converting .csv file to xlsx format date format getting changed
in CSV it is in dd-mm-yyyy but after conversion in xlsx it is showing mm-dd-yyyy.

All responses (2)

Answers (0)

Thanura09 186 on at

Like (0)

Report

Re: CSV to excel conversion date format getting changed

Go to excel and 'format cells' to your desired format
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: CSV to excel conversion date format getting changed

Hi @ManishNair56

Check the excel date column format? Could be a default setting doing this?