How to make text starting with =, – or + character in Excel

Sometimes you may want to write cell text that begins with =, – or + character. Excel, however interprets text beginning with those characters as formula and that causes an error. Trick is following:

  • Type ‘ -character as a first character. This forces Excel to interpret the cell content as text.
    e.g. typing¬†‘–> displays as –> and causes no error
This video demonstrates this:

Leave a Reply

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

*