ID: Q119085
4.00 WINDOWS
The information in this article applies to:
- Microsoft Excel for Windows, version 4.0
In Microsoft Excel, when you use the Crosstab ReportWizard with a database that has a value category with very small values (for example, 1.00E-12), you will receive zero values (0) in the crosstab table.
The Crosstab ReportWizard attempts to round up the quantities in the value category beginning at the 9th decimal place (1.00E-9). Values smaller than this are assumed by the Crosstab ReportWizard to be zero.
To work around this problem, do the following:
1. In the field to be used as the value field, multiply all quantities by
1000:
a. Enter 1000 in any blank cell.
b. With the cell containing 1000 selected, choose Copy from the Edit
menu.
c. Highlight the cells containing the small values, and choose Paste
Special from the Edit menu.
d. In the Paste Special dialog box, under Operation, choose Multiply
and then choose OK.
3. Do the following to divide the returned values by 1000:
a. In any blank cell, type "1000" (without the quotation marks).
b. Select the cell that contains the value 1000, and choose Copy from
the Edit menu.
c. Select the cells containing the small values, and from the Edit
menu, choose Paste Special.
d. In the Paste Special dialog box, under Operation, choose Divide,
and then choose OK.
Additional reference words: 4.00
Version : 4.00
Platform : WINDOWSLast Reviewed: September 14, 1996