Awesome! For years I have been spending most of my time formatting data to Dollars and moving items selected from Row counts to Value Sum. Incredible! Thanks.
@ernaolislaegers8062
2 жыл бұрын
Dear Jon, thx ever so much! I was already for a long time searching for a solution to this immense tedious job. I work with rather complex data formats and I don't format the source data for nothing! Why isn't that format copied when adding a field in a pivot? Your macro works perfect and does the trick! Thanks!
@betsyreider3658
4 жыл бұрын
A million thanks! this is a live saver.
@petehorn4696
3 жыл бұрын
Thank you!
@montpsycho
6 жыл бұрын
Very nice add-on and nice free download.
@lysenkiy
7 жыл бұрын
This is great! Thanks for sharing.
@ExcelCampus
7 жыл бұрын
Thank you Lysenkiy!
@akenower
2 жыл бұрын
I cannot tell you how many cliks this is going to save me.
@santoshshirke8842
2 жыл бұрын
is it possible to format no's by default without any macro ?
@furkanakay4954
4 жыл бұрын
Could i do apply this macro for my number data stored as text?
@pamcake712
4 жыл бұрын
I can't figure out how to buy the add-in that installs the macro to format numbers in a pivot.
@akenower
2 жыл бұрын
Did you enable the development tab? You shouldn't need to buy anything.
@ricardoanselmo868
7 жыл бұрын
Doesn't work with me... I use a brasilian version of Excel... Is there a problem???
@ExcelCampus
7 жыл бұрын
Hi Ricardo, I believe the macro should work in other language versions. I used the International property (Application.International(xlGeneralFormatName)) to return the name of the General format in other language versions. I have not tested this in another language version of Excel, but I believe it should work. What specific problem are you having with the macro? Are you receiving an error message on a specific line of code? Thanks!
@ricardoanselmo868
7 жыл бұрын
Hi Jon! Actually I followed all of your orientation. I created a pivot table and turn on the macro. Then I draged the field into the Value area and nothing happend... what I had missed????
@vinicabral
6 жыл бұрын
Probably a little late for this, I had the same problem but the macro worked fine once I named my source range
Пікірлер: 16