Excel 2002 : Anway to paste without time values ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sir,

Frequently, I need to paste large reports generated by another business
system in Excel or Excel Reader Format to Excel 2002 worksheet. Many of
these reports has date and time values in a columns

By default the Excel worksheet does not automatically eliminate the time
clock upon pasting. Usually I need to use Format Cell > Date > 14/03/2001 to
eliminate the clock manually. I find that this is a hassle time consuming
task

01-06-2007 08:32:00
01-06-2007 08:33:00
01-06-2007 08:34:00
01-06-2007 08:35:00
01-06-2007 08:35:00
01-06-2007 08:45:00
01-06-2007 09:02:00
01-06-2007 09:03:00
01-06-2007 09:03:00
01-06-2007 09:22:00


May I know is there a way to set the spreadsheet to automatically eliminate
the time clock upon pasting ?

Many Thanks

Low
 
Formatting doesn't eliminate the times--it just doesn't display them. Look at
the formula bar and you'll still see them there.

You could select the column
data|text to columns
delimited by space
choose date (mdy or dmy???) for the first field
and skip the times

And then format what you want.

But that's even more work!
 
Try this:

From your desktop

Go to Start > Settings > Control Panel

Select Regional and Language Options

Click "Date" tab

Look at Long Date format. If hour is included, remove it from the format.
 
Hello Sean,

I do what you said, but I find that the system date is set at dd/mm/yyyy and
there is no time clock behind it.

Is there any other solution ?

Thanks

Low
 
Back
Top