Article ID: 118371 - View products that this article applies to.
This article was previously published under Q118371
In Microsoft Excel, when you create a PivotTable, the formatting of any numeric values in the table is not retained.
This behavior is by design of Microsoft Excel. The data values used in a PivotTable are not formatted. For example, if you create a PivotTable that uses the following column of data
Amountthe values in the PivotTable are displayed as follows:
To format PivotTable fields that contain numbers, follow these steps:
Excel 5.0For more information about customizing a PivotTable, click the Search button in Help and type:
Pivot Tables, customizing
Article ID: 118371 - Last Review: August 15, 2003 - Revision: 1.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.