You're welcome - thanks for taking the trouble to feed back.

Pete

On Jan 11, 7:21*pm, Kent wrote:
Thank you!



"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -