Displaying formulas rather then Results

EE Pros.,

I think this is a simple problem but I don't know how to fix it.  I have cells that display the formula rather then the formula's results.  How do I change that to reflect "results" not formulas?

B.
Bright01Asked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

or pls try

Goto File /  Advanced  / Options for this worksheet:
Untick: Show formulas in cells instead of their calculated results Option

Regards
0
 
itniflCommented:
I am no excel pro, but I guess when having a equal sign in front of the formula, excel will automatically calculate it.
=A1+B1 displays as 4 when both A1 and B1 are 2.
0
 
Bright01Author Commented:
Rgonzo1971,

Thank you!  That worked.  I didn't know those options applied only to the worksheet but that's exactly what the problem was.

Thanks again,

B.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.