On 3 Mar, 17:44, "Roger Govier" <roger@technology4unospamdotcodotuk
wrote:
Hi Richard

Don't format the columns.
Right click on PTWizardLayoutDouble click the Data Field(s))Number
Format

The number format will be applied to all columns holding that data, as well
as the Grand Totals.

If using XL2007, just right click on any cell in the data areaNumberFormat
--
Regards
Roger Govier

"ra" wrote in message

...



Hello All,

Is there a way to globally define number formats in a Pivot table?
I'm familiar with going Pivot Table--Field Settings--Number, but
that only sets the format for a column.
I would like to be able to set one number format to apply to all
columns in a table.

Is this possible?

thanks and regards

Richard- Hide quoted text -

- Show quoted text -

Thanks for your response Roger. I understand how to format the Data
Feilds as per your instruction however if I have 50 Data feilds can I
Format all without Double Clicking on each individual one?