doolinn
asked on
Pivot Table - Group Data Formatting
How do I add formatting to the banding of group data in a pivot table so it shows the 1000 comma separator - changing the number format in the field setting to "number" with the 1000 separator option box selected does not change the formatting.
At the moment it shows for example 1000-1099 instead of 1,000-1,099 as a band.
See attached file example
banding.xlsx
At the moment it shows for example 1000-1099 instead of 1,000-1,099 as a band.
See attached file example
banding.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't think you can do what you want to the format of the labels in grouped mode.
Since once the label is grouped, it's no longer number and had been converted to text labels.
The only thing you can do is using F2, and edit the text labels manually.