Pivot Table - What Happened??!

[jbfrank]

I'm relatively new to Excel 2010. In previous versions, when I created a pivot table, I could right-click and format the 'Values' section and it would format all of the values in that field for every column. So, if I have 12 months worth of data, I could click on 'January', change it to a number format, and the pivot table would update all of the values for 12 months to a number format. Now I have to select the format for each column.

I feel like I'm doing something wrong and overlooking something. Surely, MSFT didn't remove this capability as an 'improvement'.

What am I doing wrong?

 

[Smitty]

In the Values field in the PT Field List, left-click and select Value Field Setting, then the Number Format button at the bottom left. Once you select your format it will apply to all of those particular values.

Conversely, you can select the entire range in the PT itself and right-click it.

HTH,

 

[jbfrank]

Unfortunately, that doesn't work either. I still have to select each month and change it to 'number format' one-by-one.

 

[Smitty]

Odd, I was working on some PT's this morning and had to apply some number formats to an entire range. I did just what I described and everything updated fine. I didn't need to format indivdual columns separately.

If you have multiple values, you might have to go the select range, then format route.

 

[elb1999]

I'm having the same issue with 2010. It's making work tedious. Is there no way to do a default value setting?