Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Truncated after Paste link in Excel 2002 | Links and Linking in Excel | |||
Paste special in Excel 2002 | Excel Discussion (Misc queries) | |||
Copy-Paste / Excel 2002 (Annoying) | Excel Discussion (Misc queries) | |||
Copy Paste / Excel 2002 (Annoying) | Excel Discussion (Misc queries) | |||
Can you paste values on multiple worksheets at one time? | Excel Worksheet Functions |