formatting pivot tables

[stephme55]

Anyway of copying formatting for columns in pivot tables? Annoying to have to go into value field settings every time.

[NeedForExcel]

If you just want to copy the formatting, try the Format Painter.

If your problem is that your formatting disappears, then there are 2 ways of Formatting Numbers

1) Right Click > Format Cells
2) Right Click > Number Format

Format using the 2nd method, and the formatting wont change.