"andrewm" wrote in
message ...

Hi I have numerous formulas with relative cells in them eg. a5, c6,
etc
I would like to change then to absolute values ($a$5, $c$6, etc)with
the edit, replace .....


Find - a - Replace with - $a$ - replace all.

Now that's not very hard, is it?