Forum Discussion
Rounding in Pivot Table
I have created six tables (in one sheet) from data in six different sheets.
From those six tables I have merged and created two pivot tables (income and expenses)
(Please don't ask how I did it as I have no idea now)
However one, only one, of the tables is rounding up the numbers.
My columns are all set to Number and two decimal places on both original data and table
How do I stop this rounding please??
9 Replies
- Please provide some example...
This is the original data which I have discovered is the only one that is General cells not Number cells
This is how it looks on the table in the lower part - 203.69 has been rounded to 204
I changed the original data to Number and refreshed the table but it did not solve the problem
Okay,
Just right click on this number and select Number format. This action will open Format cell window. The second table is pivot, right?
So, when select Number in Format cells window it will apply to all cells in current field.
Do the same for all fields.
Hope that help 🙂
