Pinterest Pixel

Pivot Table Number Formatting

John Michaloudis
Free Practice Workbook
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.
Pivot Table Number Formatting | MyExcelOnline Pivot Table Number Formatting | MyExcelOnline

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
LinkedInCopyPrintReddit
Pivot Table Number Formatting | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Top 3 Excel Pivot Table Issues Resolved

Steps To Follow

Customize Pivot Table TutorialsExcel Pivot Tables Tutorials

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...
BufferCopyFlipboardHacker NewsLineLinkedInMastodonMessengerMixPinterestPocketPrintRedditSMSTelegramThreadsTumblrVKWhatsAppXingYummly