Default figure-setting in a pivottable

P

Peter

Hi,

When I build new pivottables (in excel 2010) I spend (waste) a lot of
time in formating. I have worked a bit with styles, but I can't find a
way to set the default of the figures, showing e.g. 1,000.00 instead
of 1000.

Is it possible ?

Regards

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria for external data in a pivottable 1
Manual calculation of calculated items in multiple pivottables 2
Totals in pivottable 0
named ranges in conditional formating inside a pivottable 1
Setting a default zoom in Infopath 0
Five (equal) Pivottable to be updated in one operation 4
Cross-reference Insert Default Change 0
Excel 2010 PivotTable Oddity 2

Top