All formulas in spreadsheet programs, like Microsoft Excel, OpenOffice Calc, and Google Sheets start with an equal sign (=). To display an equal sign, but not have it start a formula, you must “escape” the cell by entering a single quote (’) at the beginning.
For example, to put the text “=hope” in a cell, type the text below in the cell.
‘=hope
Once complete, the cell only shows “=hope” and hide the single quote.
Related information
- See the formula definition for further information and related links.
- Microsoft Excel help and support.