European Currency format

Surya56
Giga Contributor

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

1 ACCEPTED SOLUTION

Simon Christens
Kilo Sage

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

find_real_file.png

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

5 REPLIES 5

Simon Christens
Kilo Sage

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

find_real_file.png

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

Irrespective with browser, Notations stays same. my locale setting also set to german, still no change.

ServiceNow tries to discover the correct Locale to use from the user Language and Country Code settings. As Simon has also hinted at above.

Unfortunately, these fields are not by default exposed in the UI. And the way they discover the locale - and what they do with undefined locales - is a bit..... weird.

If you add Country Code and Language to the user list, you can set them both to "German" or "Germany". That will make ServiceNow put together the locale "DE_de", which it knows maps to German separators, formats, etc.

You *need* to change both fields. If you don't change the language, the system comes up with "DE_en" (or something like that) and this does not match a sensible locale, therefore the defaults are applied.

The whole handling of locales, languages, formats, and currencies could really do with a MAJOR overhaul, IMO.