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: