Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Replace formula
In Excel 2000, I have hunreds of these fomulas...
=+RFE!C74 =+WEE!C184 =+SSSS!C56 =+EDW!C1043 I want to do an edit replace to make them... =+RFE!C74/1000 =+WEE!C184/1000 =+SSSS!C56/1000 =+EDW!C1043/1000 Can I do this using Edit-Replace? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Replace formula
Can I do this using Edit-Replace?
I don't think that is the way to go. Try this: -Put 1000 in an empty cell -Copy it -Select the formulas to modify -Use Edit, Paste special and pick Division as the Operation. -Click OK -Clear the 1000 when you don't need it anymore. -- Jim "snax500" wrote in message oups.com... | In Excel 2000, I have hunreds of these fomulas... | | =+RFE!C74 | =+WEE!C184 | =+SSSS!C56 | =+EDW!C1043 | | I want to do an edit replace to make them... | | =+RFE!C74/1000 | =+WEE!C184/1000 | =+SSSS!C56/1000 | =+EDW!C1043/1000 | | Can I do this using Edit-Replace? | | Thanks | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Replace formula | Excel Discussion (Misc queries) | |||
Edit Replace | Excel Discussion (Misc queries) | |||
edit replace | Excel Discussion (Misc queries) | |||
Replace "insert function" with "edit formula" button in fourmula b | Excel Discussion (Misc queries) | |||
use replace to edit a formula with wildcards | Excel Worksheet Functions |