Monday, December 12, 2011

How to group currency in a pivot table for excel?

Right now I have prices in as a Row label, such as $6.51-$9.47. I want to group them from $6-$10 in 1 dollar intervals, but when i group it, it loses the currency formating and just shows general numbers- 6-7. Anyone know how to fix this?|||In your pivot table options there should be an option that says something similar to "retain original formatting." Make sure that's checked.

2 comments: