Do you want to replace the original formula and convert the TEXT formula to
a working formula?

If so:

Select the cell(s) of interest
Goto EditCopy
Then, EditPaste SpecialValuesOK

Then, EditReplace
Find what: =
Replace with: =
Replace all

--
Biff
Microsoft Excel MVP


"Mjones14" wrote in message
...
I have a cell with the text = sum(A10:A30) as the result of a formula.
This
is because it is constructed by other formulae using values given by the
user.

How do I evaluate this text as if it were a formula?