Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers in the Values Area
formatting numbers in the Values Area
You can see that the numbers in the PivotTable’s Values area are unformatted. As an example of
formatting them as Currency, right-click any cell in the Values area and select Value Field Settings as
indicated in Figure 15-9. In the Value Field Settings dialog box, click the Number Format button as
shown in Figure 15-10.