Highlight Column B (click on the 'B' col header) press CTRL+C. click in
C1, right click, select Paste Special... and choose "Formats", click
OK.

HTH.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=486830