I want to format a column but cant copy the formating

eg A1- formula is $B$1

copying the in the A column reverts to B1.

Any answers-using excel 2003