Piovt Table-Drill Down Numbers lose Currency Format
 

I have a list with my customers' names and how much they owe.
I'm using Pivot Tables to produce various reports. When I use the drill down
feature and it creates a spreadsheet with a list of certain customers with
the amout they owe us, the drill down records lose the currency formatting
from the source list. I have to reformat the numbers to currency.

1) Question: Is there any way to prevent the lost of the currency
formatting? Is this impossible to prevent?

Any information concerning this would be greatly appreciated!
Thanks in advance.
Jugglertwo