No the INT doesn't work either.
I think that there is no way around it.
Thanks for looking anyway.
Daniel.

"Roger Govier" wrote:

Hi Daniel

Maybe =INT(A1) where A1 holds the date you want to strip the time off.

Regards

Roger Govier


DanielJW wrote:
Thanks Roger,
I've tried this before but it does not show the date in DD/MM/YYYY format. I
think it's because the day i.e. "Fri" and time "09:00" is shown in the
original. I need excel to ignore the day and date and just display
DD/MM/YYYY.
How do I get around this?

"Roger Govier" wrote:


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"?