| 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 |
| 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 | |||
Threaded Mode
