Need differnt cell format from pivot table

[SeanJ]

Alright I got a small problem please see attach spreadsheet for the data.

I have one sheet called 'Raw Data' from that I created several pivot tables. The problem is that I want to keep the format of the total column of the sheet 'Raw Data' when I click on a cell in one of the pivot table.

Thanks

Sean