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