Pivot table row total INCORRECT

I am exporting data from Access into Excel and then creating a pivot table to summarize. For some reason 6 of the 6336 summarized rows has an invlaid amount in the Grand Total cell for the row ( like 4.44089209850063E-16 when it should be 0).
I tried converting the amounts to currency on the Access side before exporting to Excel, but the six continued with non-zero amount in total cell.
I also searched Microsoft Excel to see if there was a 'fix' for this - but, no joy, possibly because I don't know the correct terms to search under.
I even tried exporting and creating the pivot table manually (normally everything is done via a module in the Access database). But even manualy, those 6 rows are wrong.
This problem is ruining my results. Solutions? Thoughts?

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Your non-zero result is a floating-point precision error.

If you had the values in Access in Currency format throughout (if Access supports it; I don't know) then it wouldn't happen.

If you can't fix it in Access, then you'll need to round it in Excel.

Post a workbook?

AHA! Finally found how to post a workbook. Here is my sample - I included the first entry as example of one working correctly. The rest on the pivot are wrong.

See the Here are some ways to get your question answered quickly part of the forum rules.

OK, I see the problem, and as I said, it's a floating-point precision issue: 29.52 - 29.00 - 0.52 <> 0. Can you not just format the data as Currency or Accounting, or does that cause a problem downstream?

The data is fine in Excel.

Originally Posted by shg

... as I said, it's a floating-point precision issue: 29.52 - 29.00 - 0.52 <> 0

That's a setting you want to be VERY careful with. In contrast to every other thing you can do in Excel, this one actually changes the data.