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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

5 Speedy Steps To An Excel Pivot Table! (infograph... G'day All, In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps...Enjoy and please comment below if you have any Excel or Pivot Table questions, I'm here to help you 🙂 DOWNLOAD ...
Add Custom Symbols With Your Numbers in Excel A cool feature within Excel is the ability to format a cell's value by pressing CTRL + 1 on any cell. This brings up the Format Cells dialogue box and under the Custom category you can customize the Type to whatever you like and even insert symbols! There are four formattin...
Show The Difference From Previous Months With Exce... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Insert a Pivot Table Pivot Tables allow you to analyze thousands of rows of data with just a few mouse clicks.  It is the most powerful tool within Excel due to its speed and output and I will show you just how easy it is to create one. If you are using a table or data set to analyze your informat...