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

Pivot Table Number Formatting | MyExcelOnline