In Numbers, how can I show a formula instead of the result

numbers

I want selected cells to show the formula instead of the result of the formula, for example cells C4 and D4 here.

Cell C4 contains "=B4+1" rather than the numerical result of adding 1 to the value in B4.

If the cell is formatted as text before I enter the formula, then the formula remains text. However, selecting text format after the formula has been computed has no effect.

Best Answer

If I understand correctly...

  • Enter the formula in the cell normally.
  • In the formula box dropdown, select Convert Formula to Text in Cell

This will replace the formula result with the formula.

Warning: This will replace the formula with text so if any other cell's formula is dependent on the converted cell it will break.

Convert Formula to Text in Cell

Animation showing conversion of formula to text

Related Question