Hi there,
I have a macro that turns numbers into the currency format that my company likes to use, and I am wondering if there is an easy way to apply this format to a field in a pivot table.
It's a pain to change the number format of a pivot field every single time I make a pivot! Any help is appreciated, thanks in advance.
Please Login or Register to view this content.
You will have to modify this code to match sheet names, pivot table name and field name. Note that the field name is "Sum of ..."
Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hi,
For the selected pivot field
or to apply to all value fields in the selected pivot tablePlease Login or Register to view this content.
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Thank you very much, this appears to be working. This has annoyed me for awhile so thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks