11

In Google Sheets I want to write a text that starts with a plus sign, but it always interprets it as a formula, and the '+' disappears. I tried specifying 'plain text' format for the cell, but it does not have any effect.

2

1 Answer 1

15

Add a single quote before the plus sign like:

----------------
| '+ blablabla |
----------------
1
  • the ‘ symbol doesn’t work. It shows the ‘ symbol after hitting enter.
    – user217215
    Apr 30, 2019 at 16:25

Not the answer you're looking for? Browse other questions tagged or ask your own question.