Changing the Numeric Format of PivotTable Data

As Figure 15–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.