Changing Multiple Formulas

J

japc90

I have a workbook wih several worksheets. Many of the cells have
similar formulas (the sum of the value of two cells located on a
separate worksheet within the same workbook divided by 390). I need to
change the number 390 in all of these cells to 370. Is there a way to
do this without manually going through every cell?

Thank you.
 
T

Teethless mama

Select your range
In the menu select Edit > Replace > Find what: 390 > Replace with: > 370 >
Replace All
 
D

Dave O

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

Farhad

Hi,

the best way is to choos a Cell for example A1 and put 370 in the cell and
then change all "390" to "A1" by find & Replace so in the future whenever you
want to change the figur to another just have to simply change the cell A1

Thakns,
 
Top