Zero value in pivot table shows a negative number in formula bar

J

Joye

I have a few cells in one of my pivot tables that should display as $0.00 in the Grand Total column
however they are showing as ($0.00), and when you select the cell, the formula bar shows a number
like -2.84217094304E-14. What is causing this? Is the error in the pivot table? In the input worksheet, the
numbers are all formatted correctly

Thank

Joye
 
Top