Does anyone know if there is a way to make the paste function ALWAYS match
the destination formattting?

To use the destination formatting paste values.
Edit, paste special, values

There is a toolbar icon that you can install:
customize, commands, edit, paste values
and you might also be interested in installing
customize, commands, edit, paste formats (same results as using format painter)

You can create a macro and assign it a shortcut key
http://www.mvps.org/dmcritchie/excel...x2k.htm#mykeys
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Libby" wrote in message ...
Does anyone know if there is a way to make the paste function ALWAYS match
the destination formattting?

Installing the "paste value" into your toolbars through customize
is one place, you can also install it into your Edit menu through customize

To get to customize right click anywhere in menu or toolbars,
or start at Tools, customize