2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)

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.