Excel convert dd/mm/yyyy to mm/dd/yyyy

A column of dates formatted as DD/MM/YY then just do this.

1 Select the column.

2 Goto Data>Text to columns…

3 On the 3rd step select DMY from the dropdown menu for column data format.

4 Now you should have ‘real’ dates which you can format as you want to via Format>Cells.