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: