Once you have entered a formula, you might decide that you no longer want the cell to contain the formula, but simply to display its result. Consequently the current contents of the cell will be protected from change (when, for instance, one of the other cells referred to in the formula changes).
To turn a current formula result into a static cell value, select the cell whose formula you wish to clear. Then choose the Clear command from the Edit menu and select Formulas. This indicates to Spreadsheet that you want to clear the formula from the cell but without deleting the result. Click on the OK button.
You can clear the formulas in a range by first selecting the range and then repeating the above operation.
This procedure is irreversible (i.e. you cannot later turn the values back into the formulas which created them), so use it with care.
Note: Clearing formulas also clears any links, turning them into static values.
See also: