Changing the data field number format


show more Changing the data field number format provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Changing the data field number format

When you create a PivotTable, Excel displays the values in the data fields without any formatting. When you look at numbers in the hundreds and below, the lack of commas and other formatting doesn't really matter. But, when you add those values in a Subtotal or Grand Total cell, the lack of thousand separators makes the values harder for humans to process. You can make your data easier to read by changing the data field's number format. To change the number format of a PivotTable data field, right-click any cell in the field, and then click Number Format.

When you do, the Format Cells dialog box appears and you can set the format for yourselves. In this case we have a number. So I'll click the Number category and then I can apply settings for these numbers. In this case all the values I am working with are whole numbers so I can set decimal places to 0 and some of my totals go over a thousand, so I will check the Use 1000 Separator box. In the United States, the 1000 separator ...

Changing the data field number format
Video duration: 2m 0s 3h 43m Intermediate

Viewers:

Changing the data field number format provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...