Niek,
That worked. But in 2007 isn't there a way to keep the formula in the fx
window when you hilight the cell containing the results as it did on 2003.

All the best,
Dick

"Niek Otten" wrote:

Hi Dick,

First re-enter the formula, as Bernard says. It's too late now to get it back via ESC

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Anvil22" wrote in message ...
| Hi Bernard,
| I tried the ESC, with no luck. The results stay in the fx window. The
| formula evaluation tool returns "the cell being evaluated contains a
| constant", the display is the formula result.
| Thank you
| Dick
|
| "Bernard Liengme" wrote:
|
| After pressing F9 you should have pressed ESC. Now you will need to re-enter
| the formula since you have made it a value.
| Why not use the Formula Evaluation tool for this purpose?
| best wishes
| --
| Bernard V Liengme
| www.stfx.ca/people/bliengme
| remove caps from email
|
| "Anvil22" wrote in message
| ...
| in the fx window I do a calculation and the formula shows in cell. If I
| hilight the formula in the fx window and press (f9) the result shows in
| cell.
| If i go back to the cell the formula no longer show in the fx window. I
| can't find how to show the formula in the fx window as it did in 2003. can
| anyone help. Thansk
|
|
|