Question: how to change wrong date format in excel?
Answer: Select the column of dates you want to convert to another locale.
Press Ctrl+1 to open the Format Cells.
Select the language you want under Locale (location) and click OK to save the change.