PDA

View Full Version : Default Number Format for Pivot Table



jcihar
10-26-2007, 12:35 PM
I have a pivot table with many number fields. When I add a field to
the table from the field list, then it has always general number format. Would it be possible to preset my own number format, which will be used for all fields I add to pivot table later.

TIA

Jiri Cihar

Djblois
10-26-2007, 12:49 PM
I haven't found a way to do this yet and I am very familiar with Pivot Tables. Sorry but I think you might have to set it each time.

Daniel

jcihar
10-26-2007, 01:07 PM
To Djblois:
Thanks for you reply, even not very chearing ;)
At least I know now it is not manageable.