Page 11 of 16PREVNEXT

PivotTable II: Swing into action with PivotTable reports

Data before and after being formatted with currency formatting

Callout 1 Amounts sold without formatting.
Callout 2 Amounts sold with currency formatting.

The report could also be made more readable for your manager by formatting the amounts sold by each salesperson as currency.

To format the numbers, you would click any cell in the data area, click the Field Settings button Button image on the PivotTable toolbar, and then click Number and select the currency format.

Page 11 of 16PREVNEXT