Formula becoming text

  • Thread starter Thread starter jblair
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Special Formula Multiply feature doesn't work anymore 2
Dependent "If" formulas 2
Excel 2010 not allowing me to paste as formula 5
I can't copy and paste equations 0
Formulas are becoming text strings 2
IF-ISTEXT formula 6
Formula help 1
copy formulas from one worksheet to an entirely different workshee 2

Back
Top