View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
japc90 japc90 is offline
external usenet poster
 
Posts: 58
Default Changing Multiple Formulas

Worked Perfectly!
Dave O wrote:
One way to do it is a simple search-and-replace: search for 390,
replace with 370. This will work, but requires caution: it will
replace all instances of 390 with 370. So if you can find something
about the formula that makes the 390 unique, you should do it. For
instance, search for /390 and replace with /370 (note the divide by
operator is included).