In Numbers, how can I show a formula instead of the result? I want selected cells to show the formula instead of the result of the formula, for example cells C4 and D4 here.



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.
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.