You can easily format your Pivot Table values simply by Right Clicking on a value and choosing Number Format. Then you can choose from the many different formats, like Number, Currency, Percentage or Custom.
STEP 1: Right click in the Pivot Table and choose Number Format
STEP 2: Choose your desired format
The Pivot table is now updated with your number formatting!
Helpful Resource:
Can you only format one column at a time or can you format more than one in a range?
Hello Mike,
You can format the whole Pivot Table with one go, here is how:
Select the Pivot Table and go to PivotTable Tools > Options > Select > Entire Pivot Table > Select > Values.
Press Ctrl + 1 to bring up the Format Cells dialogue box.
Under Number Format choose your number format and press OK.
Drop in another Values field in the Pivot Table and it will hold its format.
I hope this helps 🙂
Cheers,
John
