ExcelBanter - Edit Replace formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Edit Replace formula (https://www.excelbanter.com/excel-discussion-misc-queries/140361-edit-replace-formula.html)

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

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
|