Unfortunatly when you format the cells, then paste in to them the formatting
changes.

If you do this from within excel it will work fine, but I am pasting from
internet explorer.

I wrote a small macro to go back and change the formatting once I have
pasted, but this still does not have the desired affect.

Say I had a number "0044" upon pasting it would change to 44, then I would
run the macro which would change the field in to "special" which was set to
0000. The number will appear to be 0044, but if you look at the formula bar,
you will see that it is actuall still only 44!!!!

Still trying..

"Nick Hodge" wrote:

Mex

Try pre-formatting the cells as text

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


"Mex" wrote in message
...
Unfortunatly I am pasting in from internet explorer.
I'll explain my problem further.

I am pasting in numbers with 0's at the beginning. Therefore I loose the
0's. I need to be able to paste in to the document without loosing the 0's
and without going back after the paste to add the 0's.

Thanks

"Nick Hodge" wrote:

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?