PIVOT table - Change sub column label

[Sarfaraz]

I have a pivot table its column label is product their are four prodcuts being reflected by numbers at sub level. I want to replace these number by the product name only in pivot without changing my origional data. Can someone help me that how can I change this.

Product400003400400003402400003404400003405

I would like to change the number 400003400 wtih A and so on
Thanks

[Bob Phillips]

Post your workbook and tell us what needs changing and to what.

[Sarfaraz]

Attached please find the file Would like to change in the Pivot

400003402 as toffees
400003404 as cakes

[Bob Phillips]

Where do you propose to get the text from?

[Sarfaraz]

I would like to change this manually in the PIVOT table like I can change other field headings in pivot.