Edit Replace formula

S

snax500

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
 
J

Jim Rech

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
| 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
|
 
Top