Type an equal sign in a spreadsheet without doing a formula
Updated: 03/06/2020 by Computer Hope
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.