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

[Seba Robles]

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);

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.

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!!

 

[smozgur]

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.

 

[smozgur]

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.