How to show currency symbol in column header

• ricky969

  SSC Enthusiast

  Points: 130

  More actions

  October 4, 2022 at 1:43 am

  #4095094

  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.

  Rick

   

• ricky969

  SSC Enthusiast

  Points: 130

  More actions

  October 4, 2022 at 11:51 pm

  #4095562

  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 years, 1 month ago by  ricky969.