» Formulas Erroneously Appearing as Text
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Windows XP Pocket Reference
- Special Edition Using Microsoft Excel 2002
No comments have been submitted.
