Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Formulas
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Formulas
Select your range
In the menu select Edit Replace Find what: 390 Replace with: 370 Replace All "japc90" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Formulas
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). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Formulas
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, -- Farhad Hodjat "japc90" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is changing the comma symbol in formulas to a square box ? | Excel Discussion (Misc queries) | |||
Copying formulas without changing previous results/calculations | Excel Worksheet Functions | |||
Why are formulas not updating when changing a value in the range? | Excel Worksheet Functions | |||
How do I repeat an item in multiple formulas w/out retyping each | Excel Worksheet Functions | |||
changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions |