Excell 2007 Pivot Table Calculation changes decimal places

[FStJ]

I have a file that contains a table with source data built to 2 decimal
points. When I compare values across a defined type, the source data with
multiple occurances (both positive and negative values) converts from 2
decimals to an endless stream (example 52284.8 reflects as 52284.799999999...
in the pivot table.
Since I want a logic formula to build off of a zero difference, this returns
0.00 in accounting format and does not work properly with the if statement.
I can recreate the data, so I have a small file with the problem.

I have found a work around by using the ROUND command, but do not understand
why I have to do this when the source data does not extend beyond 2 decimals.

 

[Shane Devenshire]

Hi,

What type of calculation are you doing in the Data area of the pivot table?
SUM, Average, Count?..

Are you sure that all the source data is to 2 decimal places, not just
formatted to two decimals?

 

[FStJ]

mThx for the response. The calculation is a difference (cell minus cell).
Yes, I manually over rode the data to two decimal points to test, and still
received more decimals in the pivot.
General format was used.