Assuming your "date/time" is in A1, put this in B1:

=LEFT(A1,10)*1

and format the cell as a date. Copy down as required.

Hope this helps.

Pete

On Jan 11, 5:31*pm, Kent wrote:
I am working with data imported from Solomon Reports, and one of the columns
comes over as follows:

12/11/2007 00:00:00

When I look at the cell formatting, it is general, not formatted as
date/time. *I want to strip the 00:00:00 and just be left with the date, is
there an easy way to do this in Excel???
Thanks,
Kent