Pivot Table not using the data source's custom cell format

Seba Robles

Board Regular
Joined
May 16, 2018
Messages
61
Hello,

I have a data set in which I added a custom cell format for one of the columns (the column is named Level/Rank);

1617919736927.png


But when I add a pivot table and place the Level/Rank column under Row Labels, the pivot wont show it with the custom format from the data source.

1617919857315.png


Instead of 12, 10, 9, etc. it should say LVL 12, LVL 10, LVL 9 and so on.

Any idea if this can be done and how?

Thanks in advance!!
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,572
You can set the number format in the pivot table.
Right click on the field name in the Rows box in the Pivot Table Fields, click on Field Settings, then Number button. Set the custom format as you need.

1617921263251.png
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,572
I mean, you need to set it up in the Pivot Table as the source data number formatting is not applied in the Pivot Table.
 

Forum statistics

Threads
1,144,630
Messages
5,725,401
Members
422,623
Latest member
Dave52

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top