Formula becoming text

J

jblair

I suddenly have a problem where I copy a formula into a cell and it
becomes text and not a formula. I tried retyping the formula and no
luck it still becomes text. Help! I tried copy paste special
formula, and that didn't work.

The formula totally worked in the previous cell.

Thanks for the help

Jim
 
D

Dave Peterson

Format the cell as General first, then paste your formula into the cell.

If the cell already has the correct formula (but seen as a value),
then format the cell as General
hit F2, then enter.

Excel will see it as a formula.
 
Top