|  

» Formulas Erroneously Appearing as Text

Problem:

Column B displays the text of the entered formulas, rather than their results.

Solution:

Column B was probably formatted as text prior to the formulas being entered.
In order for the formulas to return their correct results do the following:
1. Select all the formulas.
2. Set the format of their cells to "General" or "Number".
3. Select the formulas again.
4. Press
5. Press and then Enter for each of the selected formulas.


Rate This Tip
12 34 5
Rating: 2.45     Views: 8318
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments