Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
How to Use the Excel 2013 Quick Analysis Tool
How to Add Calculated Fields to Pivot Tables in Excel 2013
How to Move Pivot Charts to Separate Sheets in Excel 2013

How to Format Values in the Pivot Table in Excel 2013

Click the Number Format command button in the Value Field Settings dialog box to open the Format Cells dialog box with its sole Number tab.

Excel opens the Format Cells dialog box.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
Create a Histogram with a Pivot Table for Excel Dashboards
Use Excel Pivot Tables to Get Top and Bottom Views
How to Create a Pivot Table with the Excel 2013’s Quick Analysis Tool
How to Move Pivot Charts in Excel 2013
How to Create a Pivot Chart in Excel 2013
Advertisement