» Formulas Erroneously Appearing as Text
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Adventure Capitalist: The Ultimate Road Trip
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
