I would like to add text that begins with an equal sign in a cell but I get the following error:



How can I set a cell's text to a string that begins with the = sign?

2 Answers 2


In Google Sheets, as in some other spreadsheet apps, typing a single apostrophe at the beginning of your entry will prevent the software parsing your input.

Type '=Hello and =Hello will appear in the cell.


One more option would be to quote it whole like


or if it's joint of something then:


and already mentioned:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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