Pivot Table - Currency Formatting Being Applied on Remove then Add Fields

[timconstan]

In my pivot table, I want to hide and show different fields at different times.

When I uncheck the box for the field I want to hide, under "Choose fields to add to report:", it hides the field like I want it to.

When I check the box to show the field, that works, but my data becomes formatted as currency! Neither my the pivot table, or that column in the source data is formatted as currency -- it's just a general number with a thousands separator.

 

[timconstan]

Solved: Need to consolidate ranges to keep the formatting I want.

http://www.contextures.com/xlPivot08.html