Copy this programming code below to paste into the Pivot Table Number Format macro described during my presentation:
1 2 3 |
On Error Resume Next ActiveSheet.PivotTables(ActiveCell.PivotTable.Name).DataBodyRange.NumberFormat = "#,##0;(#,##0)" On Error GoTo 0 |