Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Delete cell contents in Numbers keeping formula.

Apr 20, 2012 4:34PM PDT

I want to create a Ledger template from a filled in Numbers ledger. How do I delete the numbers in the cells and keep the formula??

Discussion is locked

- Collapse -
Answer
If you delete the cell upon which the formula is based,
Apr 29, 2012 12:01AM PDT

not the cell with the formula in it, then the cell with the formula in it should go blank.

For example:
Cell A10 contains the formula =Sum(A1 + A2)
Cell A1 contains 5
Cell A2 contains 2

Now cell A10 contains 7

Delete the contents of A1 and A2 and Cell A10 is now blank

That work for you

P

- Collapse -
(NT) Thanks !!
Apr 29, 2012 2:54PM PDT