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.

DOWNLOAD EXCEL WORKBOOK

 

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:

728x90

 

4

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin