Hi Fendi
Try this:

Enter value 1 in a cell then
Edit Copy this cell
Select data in your column
Edit Paste Special
Tick Multiplication
Click OK

HTH
Cordially
Pascal

"Fendi Baba" a écrit dans le message de news:
...
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