Use Local Currency Symbol

[Tony Starr]

I am feeling pretty dumb today.
I cannot for the life of me see how to format a cell so that the number will
appear using the Currency Symbol specified in the Regional and Language
settings in the Control Panel.

I want the currency symbol to change based on the regional settings, so if
the user is in Australia they will see $2.50 and if in the UK the will see
£2.50
If I format a number as currency and specify the currency symbol as $, $
still displays when I change the regional settings to UK.

TIA
Tony

 

[Joel]

currencycode = Excel.xlCurrencyCode

In the VBA help menu type currency. Then look under "International
Property" and "format currency function". It look like you have to get the
International property and then format the cells using format currency
function.