Courses / PivotTables & PivotCharts
15. Number formatting of PivotTable Value fields
Applying number formats specifically to PivotTable Value fields so formatting persists when Pivot refreshes.
Excel (PivotTables & PivotCharts)
Number formatting of PivotTable Value fields
Applying a number format directly to a PivotTable value field so the format stays intact when the PivotTable is refreshed.
"I formatted these totals perfectly — why do they revert after I refresh the PivotTable?"
Number formatting on PivotTable value fields is setting formats through the field's Value Field Settings → Number Format so Excel applies and preserves them across refreshes and pivot updates.
"I formatted these totals perfectly — why do they revert after I refresh the PivotTable?"
Number formatting on PivotTable value fields is setting formats through the field's Value Field Settings → Number Format so Excel applies and preserves them across refreshes and pivot updates.