Pivot Table Default data to format other than General
 

Is there a way to have have pivot table data default to a format other than
general. Every new pivot table I create, I end up changing data from general
format to a comma with 2 decimal format. Seems like you should be able to
have this default to a prefeered format. Is there there a way?

Pivot Table Default data to format other than General
 

Hi

Unfortunately not. You have to specify the number format you require
each time.

--
Regards

Roger Govier


"metsyoubet" wrote in message
...
Is there a way to have have pivot table data default to a format other
than
general. Every new pivot table I create, I end up changing data from
general
format to a comma with 2 decimal format. Seems like you should be
able to
have this default to a prefeered format. Is there there a way?