Question: how to change mdy to dmy in excel?
Answer: simply select all the data, right click -> Format cells and change to DMY.