I am working on a large set of data and producing a range of pivot tables.

I am also changing the result field say from qty sold to value sold and generally playing around with the data.

Each time I change the pivot table the totals revert back to 2 decimal places. Is there a way of fixing this or setting the default decimal places for pivot tables. Alternatively is this always just driven by the formatting in the underlying spreadsheet?

Owen