View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kent kent is offline
external usenet poster
 
Posts: 37
Default Stripping Information

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