Pinterest Pixel

Pivot Table Number Formatting

Pivot Table Number Formatting You can easily format your Pivot Table values simply by Right Clicking on... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Pivot Table Number Formatting | MyExcelOnline Pivot Table Number Formatting | MyExcelOnline

Pivot Table Number Formatting

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 workbookNumber-Formatting.xlsx

 

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

Pivot Table Number Formatting

 

STEP 2: Choose your desired format

Pivot Table Number Formatting

 

The Pivot table is now updated with your number formatting!

Pivot Table Number Formatting

 

 

If you like this Excel tip, please share it
Pivot Table Number Formatting | MyExcelOnline Pivot Table Number Formatting | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...