How To Automatically Format Numbers In A Pivot Table (macro) - Part 2

In this video I explain how to install the Automatic Number Formatting for Pivot Tables Macro in your Personal Macro Workbook. I also walk through the macros and code modules that make the macro work.

This includes the PivotTableUpdate event and application events that run the number formatting macro any time a change/update is made to any pivot table.

There are macros to find the source data range of the pivot table and also functions to return the number formatting of the column in the source data range, for the field that is added to the values area of the pivot table.

I also explain how the toggle button is added to the right-click menu (context menu) in VBA. This allows the user to turn the feature on/off at anytime.

The VBA project uses the Auto_Open event to add the button to the context menu when the workbook is opened.

Watch my videos series on the Personal Macro Workbook:

[fdeferia]

You have taken away my worst headache while working with excel !!! It works flawlessly!!!

[DrAbdelrahman]

Glorious As Usual and I Love you From Egypt

[MrAdrsu]

Thanks for the great video ! Exactly what I was looking for. I have installed the Macro and I can see the "automatic numbering format" option when I right click at a pivot table. However, when i click on it, it says the 'Macro may not be available in this work book or all macros may be disabled". How can i fix this ? Thanks

[matthewtschetter-qkps]

How can I set it up when I have more than one custom format in 1 column

[sammagee]

Hi great tutorial as usual, I have installed the macro and it's appearing in my right click menu but I'm using a pivot which has multiple different number formats in one column and the auto format macro is formatting all the numbers in the column to percentage format which some are but there are a few row categories where the numbers in the column should be a general number format, and they are in the source data, is there a way around this or am I doing something wrong? Thanks

[Sweetnesswithage]

Jon... I am a educational data director and I am having trouble making a pivot chart with testing information. I am in need of help. Teachers want to know what standards each student missed so they can reteach. I have the standards, but the data under standard is in percentages and when I try to plug the standard in for the student it is either blank or the number "1". What do I do!!!!????