Hello,

Is there a way to affect the default formatting of information when it
is copied from an outside source and pasted into an Excel 2000 spreadsheet?

I recently copied some information from an HTML table for pasting into
Excel. The table contains a list of part numbers, some of which begin
with zeroes, others of which contain a few letters. In any instance
where the part number begins with a zero and has no letters, any leading
zeroes are truncated and the number is formatted as a number rather than
text.

Other data fields are misinterpreted as dates when pasted into Excel.

I would like to prevent this automatic formatting.

Is there a global default setting to Excel that I can change, or is
there any sort of "pre-preparation" I can make to a spreadsheet before
pasting into it?
--

Sincerely,
Don Hicks
Portland, Oregon