Folks,
I wanted to know if there is any way that I can divide my Pivot Table data
by 1000.  In other words,

                   Data
                   +/- lbs                 +/-Sales
Product
Canine Dry     1,100,000            10,500,000
Feline Dry         500,000             6,500,000

This is a representation of the Pivot Table.  I now need to divide the
numbers by 1,000 so that Canine Dry +/- Sales becomes 10,500.

In an Excel worksheet this is easy to do (Copy 1,000 and Edit Special divide
by 1,000 over your data range).  I do not want to touch my Original Pivot
Data source.

Thanks for your help.

Shams.