Tip Printed from ExcelTip.com
Displaying zero values in Microsoft Excel
From the
Tools
menu, select
Options, View
tab.
Unchecking the
Zero
values box prevents the digit 0 from being displayed on the worksheet.
This option is useful for printing.