Formulas are becoming text strings

  • Thread starter Thread starter FrustratedinBoston
  • Start date Start date
F

FrustratedinBoston

I'm using Excel 2003
This problem has recently popped up and it is frustrating the hell out of
me. I will have a formula in a worksheet. It works perfectly fine. I then
copy and paste that formula into another worksheet. If I now click in the
copied formula in order to edit it, when I hit the Enter key after making my
edit the cell will display the formula as a text string instead of displaying
the formula result. This happens even if I don't make changes to the
formula. And these are pretty simple formulas too if that matters.

Any suggestions for troubleshooting this? It's driving me crazy!
 
I think you need to format those cells as "General" - I had that same
problem and I think that's what I had to do.
 
Check that the cells are not formatted Text; if they are then change to
General and edit the formula.
best wishes
 

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

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Formula becoming text 1
Excel Sequential Numbering System 0
formula to count text entries and return text with most entries 8
Formula acting as a string 6
Excel Formula displays text of formula 2
Excel Count If Formula Question 1
Using Text string in Sum formula 2

Back
Top