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!