Analyzing Microsoft Excel 2010 Data with PivotTable Reports

  • 8/31/2010

Changing the Numeric Format of PivotTable Data

As Figure 23-6 shows, Excel initially displays numeric PivotTable data in the General format, regardless of how it’s formatted in your source range. To fix that, right-click a cell in the field you want to change, and then click Number Format.