IF the date is being stored in Excel as a date, then select the column
and format it as DD/MM/YYYY and job is done. IF the information is
being misinterpreted, then you would need to split out the day, year
and month parts of the date and turn them back into a date serial in
the correct order.