Excel Displays Formulas Instead of Formula Results

  • Thread starter Thread starter Victor
  • Start date Start date
V

Victor

Excel displays the formula intead of the formula result
when I edit a formula.

For example in cell B2, I could have a formula that have
the following:
Cell: B2
Formula: =A1+B1
Result: 3

But if I just hit the F2 key as if I were to edit the
formula and hit enter WITHOUT even changing the formula,
the result would change to "=A1+B1".

How do I fix this bug?
 
Hi Victor,
But if I just hit the F2 key as if I were to edit the
formula and hit enter WITHOUT even changing the formula,
the result would change to "=A1+B1".

How do I fix this bug?
Click to expand...

Change the number format of the cell to anything other than text.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Subject question -- possibly you are in formula view
tools, options, view, uncheck formula view
(also can be toggled from Ctrl + ` (accent grave to left of number row)

Also check that you have calculation on automatic
tools, options, calculation (tab), calculation: automatic

Main question --
make sure you do not have a space in front of the equal sign
make sure that you have not changed to cell format to text
format, cells, number (tab), (what format)
 
Back
Top