Pivot Table Formatting

SuzNZ

New Member
Joined
Aug 17, 2004
Messages
23
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Try right clicking in the pivot table, select options and uncheck the Autoformat option.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,088
Members
412,310
Latest member
mark884
Top