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.

Pivot Table Number Formatting | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Right click in the Pivot Table and choose Number Format

Pivot Table Number Formatting | MyExcelOnline

 

STEP 2: Choose your desired format

Pivot Table Number Formatting | MyExcelOnline

 

The Pivot table is now updated with your number formatting!

Pivot Table Number Formatting | MyExcelOnline

 

Helpful Resource:

728x90

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn