Question: how to convert mdy to dmy in excel?
Answer: The simplest solution is to use the Excel data parse tool. Select the column of dates and choose Data > Text To Columns. This opens the Convert Text To Columns Wizard which is the old way of parsing data into Excel. In Step 1 select either option as you only have one column of data selected anyway.