I am assuming that you want to suppress the display of 0s in cells. Go to
Tools - Options and click view tab. Remove the check in the display zero
value check box.
This is displayed in Excel help under "Display or hide Zero Values"
"pewe" wrote:
What is the easiest way to 'empty' cells in Excel.
I have a large spreadsheet full of numeric values. If the value is '0' I
need to remove it to empty the cell.
What is the easiest way to empty these cells?
|