Mex

Smarttags where introduced in XP (2002), after 2000, so you could use the
format painter to imitate. The little icon with the paintbrush on

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Mex" wrote in message
...
Excel 2003 has the function to match destination formatting when pasting
in
to a sheet.
How can I do this in 2000?