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!

Number Formatting

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

Share on Google+

Related Posts

Add Columns to Pivot Table Slicer Buttons When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.Say that your Pivot Table Slicer is showing months from January to December.  You can change the layout of the buttons to show in 3 separate column...
Slicer Styles & Settings There are several different Slicer Styles available for you when you click on an Excel Slicer.These Slicer Styles add color to your Excel workbook to gives it some much needed life!You can also add columns to a Slicer and you can also find more Slicer options by Right...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story.You can adjust the WIDTH of the line to make it as thin or thick as you like.You can make your line chart have a COMPOUND or DASH effect.You can also add...
Group Sales with a Pivot Table A Pivot Table allows you to Group your transactional sales values by any range that you want.  You can then summarize each sales group and see the total sales and the number of transactions that they have produced.  This is useful for pricing analysis.DOWNLOAD WORKBOOK...