Forum Discussion
Rounding in Pivot Table
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?
That's in Field Settings
on ribbon
or expand within right pane
or from right-click menu on column
