Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

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.
0
Bright01
Asked:
Bright01
1 Solution
 
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
 
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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now