Home > Sample chapters > Microsoft Office > Excel

Analyzing Microsoft Excel 2010 Data with PivotTable Reports

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.