Forum Discussion
Rounding in Pivot Table
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 🙂
Hi
Thank you - yes I have done that - I have even just removed all the data in the cells that are General, changed the cells to Number, re-entered the data and then updated the table and it is still rounding.
I think that the table is bringing in the rounding from the original General cells and not respecting it has changed to a number.Because I'm not sure how to recreate what I have done I can't re-do it.
I also can't find how to access the properties to tell it to bring in the Number data and not the General (rounded) data
We speak about formatting, not about rounding. To be sure, did you apply Number format with Field settings?
