» 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:
No comments have been submitted.
