In our reports we display the currency ($) symbol in the column header for example Amount ($) or Points Value ($) etc. If we were to "globalize" our reports, how can we pick up the currency symbol from the Culture UI or the registry (for example S-1-5-18 Local system)?
I tried this but it did not work:
="Amount (" & Left(Cdbl(0).ToString("c", System.Globalization.CultureInfo.InstalledUICulture), 1) & ")"
Thanks for any suggestion.