Try

=INT(A2)

if you get an error the dates and times are text

format result as mm/dd/yyyy


--


Regards,


Peo Sjoblom


"Talladega" wrote in message
...
Hi,

I have a series of dates and time in each row. I want to create a formula
that will only take the dates. ex:

before after
11/05/2007 5:15pm 11/05/2007
12/31/2007 3:13pm 12/31/2007
09/27/2007 12.31pm 09/27/2007

Thanks,