Should calculate and display the sum. Try formatting the cell to General and
edit (F2) and enter.

--
If this post helps click Yes
---------------
Jacob Skaria


"Mjones14" wrote:

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?