Hi Daniel

FormatCellsNumberCustom DD/MM/YYYY

Regards

Roger Govier


DanielJW wrote:
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"?