Analyzing Microsoft Excel 2010 Data with PivotTable Reports
- 8/31/2010
Contents
×
- Introducing PivotTables
- Creating a PivotTable
- Rearranging PivotTable Fields
- Refreshing a PivotTable
- Changing the Numeric Format of PivotTable Data
- Choosing Report Layout Options
- Formatting a PivotTable
- Displaying Totals and Subtotals
- Sorting PivotTable Fields
- Filtering PivotTable Fields
- Changing PivotTable Calculations
- Grouping and Ungrouping Data
- Displaying the Details Behind a Data Value
- Creating PivotCharts
Changing the Numeric Format of PivotTable Data
As Figure 23-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.
){kind=link}