Pivot Table - Values section rounding value

[gheyman]

I have a Pivot table and in the Values section I have the Unit price of the product. Under Value Field Settings; I set the number format as currency with 2 decimals (Which is also the cell format on the sheet).

But when I refresh my pivot table the values come over as rounded values. $10.95 comes over as $11.00 - $3.45 comes over as $3.00

I need the table to show the actual value

Any help is appreciated

 

[igold]

Is the Pivot Table generated by a Macro or did you insert manually from a worksheet.

 

[gheyman]

Macro, but I figured it out. It wasnt the table. It was the source. The Pivot is based on a Power Query table and that field was mistakenly changed to text at one point and then changed back to currency.