Depends on what you mean by "automatic".

<Paste Special <Values
will retain the formatting of the destination cell.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"VioletMesses" wrote in message
...
How do I make "match destination formatting" automatic when I cut and
paste
things into excel??