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