Hi -
One option you might try is to use Conditional Formatting. Create a new rule for the entire spreadsheet that says if a cell value equals zero, display a blank. Just click the upper left corner of the spreadsheet grid area to select all cells, then create the new rule. Where it asks for your format, just go to Custom Format, pick the numeric format that is already there that displays zeroes and "-", and edit it to "". Finally, select the cells you want to display zeroes and create a new rule for those cells. The rule would be for cells that equal zero, then just pick any numeric format you want.
Hope that helps.
Bookmarks