Pivot Table Formatting

[SuzNZ]

Hi

I have a large Pivot table with $ columns.
I have gone Format Cells and selected the format that I want my $ in, saved s/sheet.
But then when I make a selection in the pivot the numbers that then display are unfomatted!
How do I keep the cell formatting to the style I want.

Thanks

 

[GorD]

Try right clicking in the pivot table, select options and uncheck the Autoformat option.