Microsoft KB Archive/76171

= Zeros Cannot Be Suppressed in Works for Windows Spreadsheet =

Article ID: 76171

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition

-



This article was previously published under Q76171



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,&quot;&quot;,formula) For example = If (A1*B1=0,&quot;&quot;,A1*B1) will leave the cell blank if the result is equal to 0 (zero) otherwise it will return the result.

Additional query words: ss fmt

Keywords: KB76171

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.