Pivot table total decimal places rounding

A

AM

The totals in my pivot tables have too many decimal places.
I total -$1,025.31 and $1,023.87 and the result is
$1.43999999999994 in the total cell of the pivot table but
I need just $1.44 I have formatted the table as currency
and using 97.
 
D

Debra Dalgleish

Pivot tables can lose their formatting if the data is refreshed. Reapply
the formatting, and make sure that 'Preserve formatting' is checked
(under PivotTable>Table Options).
 
Top