Excel formulas showing as text and the trick for fixing it

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:  

 

  1. Place your cursor in the offending cell.
  2. Press ctl + h
  3. Enter = into the find box and = into the replace box

Leave a Reply