Tip Printed from ExcelTip.com

---

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.