Hide formula, show result

  • Thread starter Thread starter DWJ
  • Start date Start date
D

DWJ

I have a formula typed into a cell. The cell displays
the formula not the result of the formula.
The options are set to hide formulas.
I know this has something to do with cell formats but I
don't recall the solution.

Please refresh my memory!!!

Thanks
 
Could it be that you have:
tools|Options|View Tab|Formulas checked?

Or do you have that formula cell formatted as Text?
 
Press Ctrl+~ to toggle between formula and result view.

Or

If the cell was formatted as text before you entered the
formula, then it will be treated as text, not a formula.
Format your cell to general, then press F2 and enter.
 
Back
Top