showing formulas, not values

[Catherinefsimon]

Hello,

I am using Excel 2003 and am trying to modify a formula that I input but if I double click on the cell, the formula remains instead of the output.

Any ideas on how to fix this? Not all formulas show, only the ones that I double click on and only on one sheet in my workbook. Ctrl` does not help.

Thank you,

Catherine

 

[Banker1]

Try F2, F9.

 

[Catherinefsimon]

Thank you, but this seems to substitute it for the value, I need to keep the formulas active.

 

[Aladin Akyurek]

Hello,

I am using Excel 2003 and am trying to modify a formula that I input but if I double click on the cell, the formula remains instead of the output.

Any ideas on how to fix this? Not all formulas show, only the ones that I double click on and only on one sheet in my workbook. Ctrl` does not help.

Thank you,

Catherine

Run Edit|Replace with:

Find What set to: =

Repace With set to: =

and activate the Replace All button.

 

[Catherinefsimon]

Thank you, I turned my back for 10 minutes and double clicked again and the problem dissapeared, it is a mystery but next time I will try that, thanks again!

 

[Banker1]

Thank you, but this seems to substitute it for the value, I need to keep the formulas active.

Misunderstood you're original post. Looks like Aladin answered your question.