Formula staying as a formula in a cell?

[Eric]

Does anyone know why a formula stays a formula in a cell?
I know that using the aspostrophe makes it like a string,
like '=blah+blah, but this one doesn't...I even have made
the cell General and made sure that calculate automatic
was selected. This thing is driving me nuts. Any
suggestions???

 

[Ken Wright]

You can't just format the cell as general if it was text to start with. You need to format as
general AND then hit F2 and then enter. the other possibility is that you have the Formulas view
turned on in Tools / Options / View Tab / Uncheck Show Formulas in Window options.

Ideally you should format the cells as general before you enter the formulas

 

[JS]

it might be worth checking Tools - Options - View and making sure formulas
is not ticked.

 

[Eve]

-----Original Message-----
Does anyone know why a formula stays a formula in a cell?
I know that using the aspostrophe makes it like a string,
like '=blah+blah, but this one doesn't...I even have made
the cell General and made sure that calculate automatic
was selected. This thing is driving me nuts. Any
suggestions???
.
Uhm, have you tried hitting enter after you put the

formula in the cell? That should work at least it does for
me

 

[Loren]

also be sure there is no space in front of the = sign