View Single Post
  #1   Report Post  
andrewm
 
Posts: n/a
Default replace function


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 .....

can anyone help

thanks


andrew


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=388266