Solved

Displaying formulas rather then Results

Posted on 2013-11-03
3
145 Views
Last Modified: 2013-11-03
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
Comment
Question by:Bright01
3 Comments
 
LVL 2

Expert Comment

by:itnifl
ID: 39619801
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
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39619805
Hi,

or pls try

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

Regards
0
 

Author Closing Comment

by:Bright01
ID: 39619846
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now