What you could do, though, is to have a separate sheet in the workbook
you paste this external data to, set up with the formats you require.
Then copy from this sheet and click onto the other sheet and use Edit
| Paste Special | Formats to impose your formats onto the imported
data.

Hope this helps.

Pete

On Aug 6, 4:14 pm, Mr. Low wrote:
Dear Sir,

No, Excel 2002 does not allow me to paste special on those extternal source
of data. The normal dialog box does not come out to enable me choose my
pasting options.

Thanks anyway for your info.

Low
--
A36B58K641



"Gizmo63" wrote:
This works for 2003 and 2007 but I'm not 100% sure for Excel 2002.
When pasting try
[edit] - [paste special] then select 'Values'.

Providing the structure is the same you should just get the numbers with
your own formats.
If you want to retain any calculations that you're copying across the select
'Formulas' instead of 'Values'.

HTH
Giz

"Mr. Low" wrote:

Dear Sir,

Frequently, I need to copy and paste reports generated by other business
system to Excel Worksheet for further analysis.

These reports usually come in Excel Reader or Excel Formats.

I find that whenever these reports are pasted to the Excel Worksheet, it
retain it retain its original formatting instead of following the default
formatting of my worksheet.

The formating involve are font type, font color and date format.

Usually I need to customize it back to my desire format manually.

I feel more comfortable working with MS San Serif blue font and do not
require the time clock after the date

This is time consuming and tedious when dealing with large number of big
spreadsheet daily.

May I know is there a way to set the Excel 2002 worksheet to retain my
desire formatting after pasting?

If this is not possible for Excel 2002 , may I know if this feature is
already available under Excel 2007 ?

Thanks

Low

A36B58K641- Hide quoted text -

- Show quoted text -