Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

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.

Download the file that contains the free macro: https://www.excelcampus.com/pivot-tables/automatic-default-number-formatting

Download the PivotPal add-in that contains the feature: https://www.excelcampus.com/pivotpal

Watch part 1 of this video series where I give an overview of how the automatic number formatting macro works: https://youtu.be/xW5tlzSdx-A

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:
Playlist: https://youtu.be/rD2-mSbTuL0?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_
How to Create the Personal Macro Workbook: https://youtu.be/rD2-mSbTuL0
Where is the Personal Macro Workbook Stored: https://youtu.be/6cynP3OkIT0
How to Add Macro Buttons to the Ribbon: https://youtu.be/dmdolFcS-fI
How to Add a Yes/No Pop-up Box Before the Macro Runs: https://youtu.be/rCh7ki9yVsM

Page where Personal Macro Workbook files can be downloaded: https://www.excelcampus.com/vba/personal-macro-workbook-video-series/

The Automatic Number Formatting Feature has been added to the PivotPal Add-in: Here is a video that explains the new feature: https://youtu.be/32Xd3K3Funk