Friday, 25 January 2013

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:

No comments:

Post a Comment