View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GregP1962
 
Posts: n/a
Default Copying formulas to other cells. Keeping references w/o $ sign.


-Gary's Student says;

First select the cells
Then use find/replace to change all = into x=
This will change all the formulae into text strings.-

Um, after selecting the cells, there is no clear way in find/replace to
change all = into x=.


What am I finding? The dialog box after edit/find is confusing.


--
GregP1962
------------------------------------------------------------------------
GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063
View this thread: http://www.excelforum.com/showthread...hreadid=528771