How to show currency symbol in column header

  • 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)?

    Screen Shot 2022-10-03 at 6.37.41 PM

    I tried this but it did not work:

    ="Amount (" & Left(Cdbl(0).ToString("c", System.Globalization.CultureInfo.InstalledUICulture), 1) & ")"

    Thanks for any suggestion.

    Rick

     

  • I tested this solution and it worked. I'm still trying to find a more polished way of achieving the results, though.

    =Replace("Valore Punti (" & FormatCurrency(0, nothing) & ")", "0", nothing)

    • This reply was modified 2 months ago by  ricky969.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply