are the dates "real" excel dates or dates entered in text format ? if you format the column with dates in as general do they all turn into 5 digit numbers or do they still look like dates.
if they stay as dates when formated general
select the column of dates
then data tab/text to columns click next twice select the date option and choose dmy from the dropdown
click finish