How to empty a cell in Numbers without formatting the cell

numbers

How do i delete all the content from a Numbers sheet without formatting the cell?
Using google it says to use the delete button however it does empty all the functions and format as well.

I have my cells formatted with popups, percentages and dates which i need to keep.

Best Answer

A formula, if it exists, is part of the contents of a cell. It is not possible to delete the outcome of a formula without deleting the formula itself.

Related Solutions

In Numbers, how can I determine the default formatting of cells in rows that have just been added to a sheet

I found the following tutorial at Apple that has the answer to my own question: The default table styles are always taken from the table style list that you choose from the panel on the bottom-left corner of the screen.

The solution to my problem is to use the Create New Table Style command under the Format menu and adding a brand new table style. As long as this new style remains selected, it is the one that the table will keep as a whole.

I have tried this at home and it works as advertised.

How to handle Numbers’ automatic Data Formatting

Without access to the spreadsheet that you've shown, I've attempted to recreate this myself. It appears that there are two things wrong with the spreadsheet above:

The test-array for the countif is of Data Format Automatic. This means that the zeros are not of format Duration and can't be compared by the countif.

To fix this, select the entire array and choose Duration from the Data Format list.
The countif's condition is of format Number whereas the test-array is of format Duration.

To fix this, use the following for the countif cell:
```
=COUNTIF(G2:G11,">0h 0m")
```

Best Answer

Related Solutions

In Numbers, how can I determine the default formatting of cells in rows that have just been added to a sheet

How to handle Numbers’ automatic Data Formatting

Related Question