Pivot table Field Setting Number Format
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
|