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.

  • See the formula definition for further information and related links.
  • Microsoft Excel help and support.