Piovt Table-Drill Down Numbers lose Currency Format

J

Jugglertwo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting SSAS pivot tables to indicate drill through available 0
filter on currency number format 3
Pivot table drill down 0
Format Drill to Details Table 4
sort order of pivot table drill down 0
Excel 2007 Pivot table cells number format changes w/out user inpu 0
Pivot Table - Drill down to source and update 1
Pivot Table drill down 1

Top