formula is displayed as literal text instead of formula result

  • Thread starter Thread starter carlossaltz
  • Start date Start date
C

carlossaltz

I have been having trouble frequently with formulas appearing as litera
text in the cell instead of a formula with a result.

Does anyone have any suggestions as to what I may be doing wrong
 
The cell you're working in is probably formatted as text. Try changing
the format to something appropriate.
 
If you are entering the formula correctly as in =2+5 and you see =2+5 it
would mean one of two things.

1. You have "View Formulas" set on in that file. Hit CTRL + `(back quote) to
turn off formula view.

2. The cells were pre-formatted as Text. Re-format to General then F2 and
ENTER each cell.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Formula displays as formula, not as result 2
Displaying results in formula bar when cell is hidden 1
Cell displays Formula text 1
Dependent "If" formulas 2
Formula displays instead of text result 2
Formula result disappeared 5
Excel VBA 1
Formulas are becoming text strings 2

Back
Top