[Solved] Format Numbers in a Pivot Table

[b.mckerchar]

My pivot table shows numbers with decimal places and I want to format these numbers to display the numbers without the decimal places.

Please guide me as I cannot find a way to do this.

[FJCC]

Short answer:
Set the Pivot Table Value and Pivot Table Result cell styles to have an integer number format.

Longer answer:
Access the Styles & Formatting tool, either in the Sidebar where it is the second icon down, or through the menu Format -> Styles & Formatting. Click the Cell Styles icon, which is the left icon of the two small icons near the top left of the Styles and Formatting window. RIght click on the Pivot Table Value style and select Modify. On the Numbers tab, set the category to Number and the Format to -1234, which has a format code of 0. Click OK and the numbers in the body of the table will be shown as integers. If you want to totals to also be integers, modify the Pivot Table Result style in the same way.

[b.mckerchar]

Thank you FJCC, resolved.