Excel 2007 Pivot table takes 2 decimal source data and converst to multiple open ended decimal RRS feed

  • Question

  • 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.



    Thursday, June 11, 2009 3:16 PM