Cell shows formula not the result

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
 
J

Jenn

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
 
J

Jeff Granger

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
 
J

Jenn

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

Jenn
 
Top