How Do I Quickly Change a Pivot Field Number Formatting with VBA?


Is there a way I could change the number formatting of all my pivot fields without having to spend forever on it?!

Sure! The VBA snippet below has some of the most common number formats, which you can directly re-use in your code!

PS. Do make sure to un-comment the formats that you do not need! Otherwise your preferred one may get overwritten.

Also, the code above will modify all the value fields in all your pivot tables across your workbook.If that’s not what you need, you will have to implement some conditional statements


Happy VBA coding!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.