Changing the column to test revert all my #'s to the wrong format (the
one I am trying to get rid of). I need something that will pre set the
column for future pastings. Right now, all I can do is change either
one at a time or I can change the whole column until the next time I
paste and that new number goes is as 2.5001E+11.


--
kbooz
------------------------------------------------------------------------
kbooz's Profile: http://www.excelforum.com/member.php...o&userid=36920
View this thread: http://www.excelforum.com/showthread...hreadid=566297