Excel 2002 : Anway to paste without time values ?
 

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

--
A36B58K641

Excel 2002 : Anway to paste without time values ?
 

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!

Mr. Low wrote:

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

--
A36B58K641

--

Dave Peterson

Excel 2002 : Anway to paste without time values ?
 

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.

"Mr. Low" wrote:

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

--
A36B58K641

Excel 2002 : Anway to paste without time values ?
 

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




--
A36B58K641


"Sean Timmons" wrote:

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.

"Mr. Low" wrote:

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

--
A36B58K641