formula displays as a formula, not as its result

  • Thread starter Thread starter dido22
  • Start date Start date
D

dido22

Hi,

I am using excel 2007.

I have a simple formula in a cell , the cell displays the formula, not its
result.

I have checked under excel options/advanced/worksheet, the option 'show
formulas ....' is un checked.

Formats are set to 'general'

Help please ?

Thanks

KK
 
dido22 submitted this idea :
Hi,

I am using excel 2007.

I have a simple formula in a cell , the cell displays the formula, not its
result.

I have checked under excel options/advanced/worksheet, the option 'show
formulas ....' is un checked.

Formats are set to 'general'

Help please ?

Thanks

KK
Click to expand...

Maybe...
Did you change the cell format to "General" after you entered the
formula? If so, select the cell, hit F2, hit Enter. The formula should
now show a return value.
 
Back
Top