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.