That's a nuisance. Are you confirming there's a bug? Why does Excel change a
perfectly good format?
Omen

"ShaneDevenshire" wrote in
message ...
Just format the Pivot Table.

Put your cursor in the pivot table field and click the Field Settings
button
on the toolbar. Click the Format button...
--
Cheers,
Shane Devenshire


"OldManEd" wrote:

I have a column that has been formatted as an integer, no decimal. When I
create a pivot table this column shows up as currency format. Is there
something I should do BEFORE starting to create a pivot table??
OMEd