Question: how to change date format in excel.csv?
Answer: Open your file in Microsoft Excel.
Right-click the column containing dates.
Select "Format cells"
Click "Date" under Number >> Category.
Ensure the Location (Language) is set to be United Kingdom (English)
Select formatting that shows the date in the dd/mm/yyyy format.