Sorry, total newb question here but I lack the proper vocabulary so I'm
having a difficult time finding this answer in help or online. I have
several rather lengthy formulas that I've already entered. After
entering them, I've found I've made something of a major error in not
including the $ sign in front of the cell references. I now need to
copy the formulas and the auto re-assignment of the cell references is
just killing me. Editing them all manually will take ages. Is there
any way to automatically add the $ sign to all cell references in an
existing formula?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=466761