Problem: You change a formula and Excel displays the formula instead of the result.
- You try to change the formatting to “text”, but that does not fix it.
- You try to toggle on/off the “show formulas as text” option, but that does not fix it.
Solution:
- Place your cursor in the offending cell.
- Press ctl + h
- Enter = into the find box and = into the replace box