Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

Showing currency format in pivot table dependent on country

hi
Just wondering is it possible to format a pivot table so that it shows the currency appropriate for that country e.g. if I pick UK from Report filter (for example) that the number is shown as sterling or if I pick a country from the Eurozone it appears as euros?
Thanks.
Avatar of Anastasia D. Gavanas
Anastasia D. Gavanas
Flag of Greece image

A macro could probably do that quite easily
Can we have a small sample with all the possible currencies you want?
Also you may try to have the data formatted as you want (use custom formats)
Then there is a whole tutorial on how to maintain these formats in your pivot table here:
http://www.launchexcel.com/preserve-pivot-table-number-format/
Even if the format changes, the currency value will NOT be converted (i.e. the actual NUMBER).
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agwalsh
agwalsh

ASKER

@paulsauve - thanks for that. It's just the actual FORMAT that's been looked for and MatthewsPatrick has just given me that in a great format -...thank you :-)
Avatar of agwalsh

ASKER

Just what I was looking for :-)