View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Excel 2002 : How to eliminate the time value after the date ?

Sounds like the data is in text format
make sure there are empty cells to the right of your data set
select the date time data
Data-Text to column
delimited
next
select space
next
date MDY
finish
clear the time cells

"Mr. Low" wrote:

Dear Sir,

I run a report using another business system in Excel Reader Format. I
copied the report and pasted it to an Excel 2002 Worksheet.

Under the date column, I have a block of date that shows the time as well.

I need to eliminate the time value after the date as it takes up to much
space.

I tried to Right Click Format Cells Date *14/03/2001 but it did
not work.

All other date format also did not work. The cells are not protected cells.

Could you please show how to do the conversion as illustrated below ?

Before conversion After conversion
Date Date

8/25/2005 12:00:00AM 8/25/2005

8/25/2005 12:00:00AM 8/25/2005

4/15/2002 12:00:00AM 4/15/2002

12/3/2003 12:00:00AM


Thanks

Low




Thanks



Low


--
A36B58K641