Look in Excel VBA help at the International Function, specifically
xlCurrencyCode

--
Regards,
Tom Ogilvy

"JT" wrote in message
...
Where can I get a list of countrysettings. I need to
format amounts in my macro depending on the country
setting?