Cell shows formula not the result

  • Thread starter Thread starter Jeff Granger
  • Start date Start date
J

Jeff Granger

I type "=A1+B1" in cell C1.

Cell C1 displays "=A1+B1", not the result of the formula.

Tried CTRL +` but that just seems to make the colums thinner.

It's driving me nuts!

Can anyone help?

Jeff
 
Hi Jeff...
There is either TWO things happening...

1. Remove the quotations...unless you posted them here for display
purposes.

OR

2. Go to TOOLS/OPTIONS on the VIEW tab (at the bottom) Window
Options...Uncheck the box that reads FORMULAS.

Let me know how you make out.

Jenni
 
Format your cell as something other than Text, then reenter the formula.
 
Jenni

Yes, the quotes were just for clarity, I didn't actually type them in.

Tools | Options | Formulas is unchecked, so it must be something else ??

Jeff
 
I wish Jeff...that's all I can think of. Is this the only workbook it
does it in...or everyone you open?

Jenn
 
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

somewhat complicated conditional formula 2
Show other cell if blank 5
onerror or catch exception/error on Excel? 2
Formulas 5
Formula help 2
Cell colour change if formula displays false 3
Parsing help requested 3
Another simple formula?? 20

Back
Top