select your cell with the formula

go to the formula bar.
Highlight each cell reference in the formula successively and Do F9 on each
one. after you see the value, do escape to restore the formula. Then do
the next reference. You can select any complete subset of the formula (or
the whole formula) to evaluate it.

--
Regards,
Tom Ogilvy

"David Smith" wrote in message
...
Hi Roger,

It there any utility for that. I am just interest in seeing the reference
values temporarily in order to audit values against what is known that
they
should be.

Thank you....

David S


"Roger Govier" wrote in message
...
Hi David

=A1&" * ("&B2&" + "&C4&") / "&D2

Regards

Roger Govier


David Smith wrote:
Hello,

Is there a way (addin utilities or otherwise) to cause the formula in a
cell to display the values for the component references making up the
formula?

-i.e =A1 *(B2+C4)/D2

would display based on the cell reference values as:

=5*(4+6)/8

Thanks for your help,

David S