View Single Post
  #4   Report Post  
Jai
 
Posts: n/a
Default

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?