- I have been busy last few days both at office and home. While work is keeping me busy at office, at home I am occupied with learning how to drive.
-
I took my permanent license exam today and failed miserably. My examiner was surprised that I failed on so many counts, once I actually joined the opposite lane upon turning left, the examiner almost fainted and told me aloud to change lanes, think I got way too confused and tensed up, well whatever is the case I am going to test another time later next week, hopefully this time it should go through. - I am going to schedule a server move for PHD probably this weekend. I am just going to move all my stuff from the current server to something more professional and large enough so that I dont have to worry about the increasing traffic and bandwidth for a while.
PS: If you can tell me what is the original source of the above image I will add your blog to my links list on sidebar, first one to respond wins 🙂
[Bored at work? Read the earlier blah :1 , 2, 3, 4, 5, 6, 7, 8, 9, n, 11 ]
4 Responses to “Currency format Pivot fields with one click [Friday VBA]”
As in your example, I often find myselve having to format numbers as kU, MU,%, or increase/decrease decimals. In the PowerPivot utilities add-in, I have included several such formatting macros and made them available from the pivot table contextual menus. Thanks for you post. It reminds me that formatting as currency is *currently* missing.
The add-in is free and the vba code open.
https://www.sqlbi.com/tools/power-pivot-utilities/
I almost never format my pivot tables. I only format my final chart/table or whatever.
And when I do format them, I go the long distance. Keeps my clicking ability in shape. 🙂
I'm with GraH
I rarely if ever format PT's
Just hover your pointer on field header, it turns into down arrow then click. Entire pivot field gets selected then click on currency($) symbol from home ribbon or Press Ctrl + $(Ctrl + Shift + 4).