If you select the bit you mentioned which is above 1 and left of A and then
hit copy, then select the same place in the detsination sheet and hit paste,
all the formatting should take, including column widths etc. Now just paste
special with values and the data should be right also.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip