I'm using excel 2010 and want to know if there is a way to set default value settings. I'd like for my formatting to be in the currency format, but whenever I move fields out of the values area of the pivot table. I have to reformat them when I bring them back in.