On the celd show a formule not its value, why??

A

adis

I have in the worksheet, one celd that show it a formule (i don't know why)
not its value.
Anybody, why it the reason? and how do i to show the value?
 
G

Gary''s Student

1. clear the cell
2. format the cell as General
3. re-enter the formula
 
M

Mike

if it's only one cell then check it isn't formatted as text. Cut the formula
re-format as general and paste it back
 
N

NikkiR

In Tools - Options - View you can tick to show the formula instead of the
answer with the tick box 'formula' I would suggest clicking on your cell and
then going in the options and unticking the box.
 
G

Gord Dibben

Re-format as General then F2>ENTER is sufficient.

No need for cutting and pasting.


Gord Dibben MS Excel MVP
 
Top