Set custom symbol for currency, decimal and thousand separator

Set custom symbol for currency, decimal and thousand separator

Posted by: rabin.shakya on 5 December 2017, 9:26 am EST

• 

  rabin.shakya

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 December 2017, 9:26 am EST

  I am not able to figure out how to change the currency symbol, and decimal/thousand separator symbol (comma or period).

  When I set the format to “n2” it will use comma as the thousand separator and period as decimal separator symbol. When I set the format to “c2”, it will use $ as the currency symbol and also will not give me option to not use thousand separator symbol.

  In our application we give users ability to specify these things so we need to be able to set change it. Please let us know how we can change those symbols and not use thousand separator on currency format.

  Thanks!!!

• 

  meenakshi.singh

  

  • Post Options:
  • Link
    Copy

  Posted 6 December 2017, 5:53 am EST

  Hi!

  In order to remove thousand separator on currency format, you can use a custom string like this - “$#.00”.

  For detailed information on custom format strings, you can also follow the given link:
  
  https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-numeric-format-strings

  Regards,
  
  Meenakshi