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

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>