Excel 2002 : Anway to paste without time values ?

M

Mr. Low

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
 
D

Dave Peterson

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!
 
S

Sean Timmons

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.
 
M

Mr. Low

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top