G

#### Guest

Table.

I believe it is a definite bug, but find no mention of it in Microsoft

Knowledgebase.

The pivot table modifies the values from the source by adding decimal level

detail that is not accurate.

Do the following to recreate (in Excel XP / Excel 2003):

Sheet 1: A1: Project , B1: Amount, A2: Test; B2: -18.25, A3: Test! , B3

18.01.

Create a pivot table with Project as the row, and Amount as the Data.

The formatted results will display -.24, however, if you click on the cell

and look in the formula bar, the number displayed is -0.239999999999998.

I have other situations where pivot table values are displayed even when the

total is exactly zero.

I'd like to know if there is a patch to fix this or if it is corrected in

the 2007 version; if not, I'd like to know how to report this to Microsoft

as a bug;