When I copy a date format from outlook it copies into excel as such: "Fri
25/11/2005 09:00"
How can I get excel to recognise this as a date field and reformat into
"DD/MM/YYY"?