Excel 2002 annoyance - pasting formatted data loses formatting

[George Radion]

Greetings List
I am using Excel XP amd Access XP
I regularly run queries in Access and cut and paste the results into a
new Excel spreadsheet.

The Access data is usually formatted numeric, fixed, zero decimal
places.
Once pasted into Excel, it gains 2 decimal places and I get the little
green triangle in each cell inviting me to convert to numeric of error
check etc.

Can anyone think of a way to retain the numeric formatting from the MS
Access data?

Regards
George

 

[Dave Peterson]

Debra Dalgleish has posted a couple of techniques for fixing this after the
fact:

http://groups.google.com/[email protected]