Enter two empty helper columns to the right of your date column
select the date/time date
Data-text to column-
select delimited
next
select space
next
select date MDY
enter
delete the two helper columns


"Fendi Baba" wrote:

I export a set of data from SQL and have a column showing dates. An
example of this format is
5/13/2007 6:19:07 PM which is May, 13 2007. I need to format this
column to show just the date without the time element. but excel wont
recognise this as a date. How can I work around this?

Thanks for your kind advice.

Regards