Another trick you can try in place:

1) Highlight the column of dates
2) Click on Data > Text To Columns > Delimited > Next > (uncheck all options) > Next > Date (DMY) > OK