Formula staying as a formula in a cell?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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???
 
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
 
-----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
Click to expand...
formula in the cell? That should work at least it does for
me
 
Back
Top