Zeros Cannot Be Suppressed in Works for Windows Spreadsheet (76171)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
This article was previously published under Q76171

SUMMARY

Version 2.0

Zeros cannot be suppressed in the Works for Windows version 2.0 Spreadsheet. Also, there is no way to suppress zeros in a cell containing a formula in the Spreadsheet. However, if a cell contains only the value 0 (zero) and does not contain a formula, you can clear the cell by choosing Clear from the Edit menu (ALT, E, E) so that zeros won't appear.

Version 3.0

To suppress zeros calculated from a formula in a Works for Windows version 3.0 Spreadsheet, use the IF Function: 
   =If (formula=0,"",formula)
For example 
   = If (A1*B1=0,"",A1*B1)
will leave the cell blank if the result is equal to 0 (zero) otherwise it will return the result.
Modification Type:MajorLast Reviewed:10/6/2003
Keywords:KB76171
©2003 Microsoft Corporation. All rights reserved.