Are you selection 'Formats' in the Paste Special dialog box?

To get what you want
Select Cell b3
Click on the Paint Brush icon
Click on Col B
this will copy the formatting to Col B

"Shannon" wrote:

Ok - when I do that then whatever is in the cells in column b change to the
value from "b3"... How can I make it so the values don't change to "b3"'s
value??