ok, so when you paste to a new column, go to edit---paste special...
then click in the button values!

that should work! ;)


--
rae820
------------------------------------------------------------------------
rae820's Profile: http://www.excelforum.com/member.php...o&userid=24135
View this thread: http://www.excelforum.com/showthread...hreadid=377544