European Currency format

Surya56 · ‎07-02-2020

How to make currency format to be European (420.000,00 instead of 420,000.00)

Simon Christens · ‎07-02-2020

Hi Surya

Can you confirm that no matter what browser your using the format is always the same ?
Because i have been delimiters change depending on Browsers (Chrome vs Firefox)
You can also open the Developer tool in your browser and (F12) and under "HTML" search for "g_user" or "separator" to check the separator in the current browser

There are plenty of similar questions on the community about the same

Ex:
https://community.servicenow.com/community?id=community_question&sys_id=ec2b07eddb5cdbc01dcaf3231f96...

Quote:
1. Changing the system property locale to e.g. de.DE or nl.NL does not 😞 change my behavior for decimal fields to dot vs comma notation. It still presents 12,000 vs the expected 12.000

2. Add the fields Country Code and Language to a user record and e.g. supplying Dutch values (so Country Code = NL; Language = nl) DOES 😄 change my decimal notation to dot-notation

So try chaning the Country code and Language on the given user and check if the decimal and grouping separator changes accordingly

View solution in original post

augustinchacko · ‎07-03-2020

Hi Surya,

Please go to "sys_properties" table and change the settings for below properties which will give you desired output like 420.000,00.

1. glide.excel.convert_to_user_currency :- Set the value into 'True'

2. glide.excel.fixed_currency_usd :- Set the value into 'False'

3. glide.system.locale :- Set desired user session value in the field for example :- fr.CA (English Ireland) Refer below link for available details

https://www.oracle.com/java/technologies/javase7locales.html

Thanks,

Augustin Chacko