Question -

When I am analyzing a formula in the formula bar, i can double-click on
any of the cell ids (ex. A2), hit F9, and have the entry in the formula
convert to the value in A2. Is there any way to expand this
functionality in the following manner:

I want to be able to change ALL of the cell references within a formula
to their values, while PRESERVING the formula structure.

Ex:

=A2+A5/A6+EXP(A7)

after running some code (presumably), I would like the cell to display

=1+4/5+exp(4)

I sincerely doubt this is possible, but if it is, I would love it. It
is a pain in the rear going through long formulas changing everything
to values... Professor wants the numbers though, so that is what I must
do.

Please help?
-mykenk