Microsoft Office Tutorials and References
In Depth Information
Formatting Numbers in the Values Area
figurE 15-7
figurE 15-8
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.
 
Search JabSto ::




Custom Search