Automatic Number Formatting with the PivotPal Add-in
169 بار بازدید -
7 سال پیش
-
The Automatic Number Formatting feature
The Automatic Number Formatting feature applies number formatting to the cells in the values area when you use the Pivot Table Field List to build a pivot table. Sometimes you might not want to open the PivotPal window to build your pivot table. So this feature applies number formatting to the cells in the pivot table when you add fields to the values area.
The Automatic Number Formatting feature will apply the number formatting from the field (column) in the source data range. If the column contains General formatting, then default number formatting will be applied. The default number format is the first number format in the My Number Formats window.
The option can be turned on/off from the right-click menu within the pivot table.
The Automatic Number Formatting feature will apply the number formatting from the field (column) in the source data range. If the column contains General formatting, then default number formatting will be applied. The default number format is the first number format in the My Number Formats window.
The option can be turned on/off from the right-click menu within the pivot table.
7 سال پیش
در تاریخ 1396/04/28 منتشر شده
است.
169
بـار بازدید شده