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 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Changing the data field number format

When you create a Pivot table, 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 the subtotal or grand total cell, the lack of 1000s 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 Pivot Table data field, click any cell in the field and then on the Pivot Table toolbar, click the Field Settings button. In the Pivot Table Field dialog box, verify that you have the proper field selected and then click Number.

Now you can use the controls on the number page of the Format Cells dialog box to change the Number's format. In this case, I'll go with Number, which is a good generic format for any sort of numeric data. My values don't have any numbers to the right of the decimal point, so I will s...

Changing the data field number format
Video duration: 1m 42s 1h 7m 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 2008 for Mac: Pivot Tables for Data Analysis

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