excel 2007 formulas

[Anvil22]

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

 

[Bernard Liengme]

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

 

[Anvil22]

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

 

[Niek Otten]

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


| 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
| >
| > | > > 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
| >
| >
| >

 

[Anvil22]

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

 

[Duke Carey]

On my install of 2007, the formula bar works just the same as it does in 2003.

Do you have "Show Formula Bar" unchecked in the Display options? Click on
the Office button, go to Excel Options, select Advanced, and scroll down to
Display

 

[Anvil22]

Duke,
That worked like a charm. I reeintere the formulas and they now show when I
return to the cell.

All the best,

Dick