Format number in Excel pivottables
When I work with pivottables in Excel and updates or changes the facts/measure I typically have to change the numberformat to show no decimals I have made this small macro to do via a shortcut key or just run the macro when you a selected a value cell in the pivottable..
If IsObject(ActiveCell.PivotCell) Then
ActiveCell.PivotCell.PivotField.NumberFormat = “#,##0”
Add it to your personal workbook and add a short cut key to the macro and you are good to go :-)..