Expanding the F9 functionality

[[email protected]]

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

[Bob Phillips]

It is possible but it is fiddly.

Select the cell, then select one of the cell references in the formula bar
and hit F9. This will then evaluate that cell, so just hit enter. Then
repeat individually for each cell reference.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> 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
>