Pivot table total decimal places rounding

  • Thread starter Thread starter AM
  • Start date Start date
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.
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table grand total location 1
Referencing a pivot tables Grand Totals Column 1
Counting number of items excluding duplicates. 1
Inputing data into Pivot Table 2
Pivot Table Column Totals - XL2003 5
Grand Totals for Pivot Tables 4
Pivot Table totals 3
XL2007 - Pivot Table Limitations 2

Back
Top