Expand my Community achievements bar.

Display pattern numeric field

Avatar

Former Community Member
Hi,



I want to display always this format for numeric fields:

1.203,45



So if the user fills in:

1) 12.34 -> is formatted to 12,34

2) 12,34 -> it should stay 12,34, but it becomes 0,00

3) 1203,45 -> is formatted to 1.203,45

4) 1.203,67 -> it should stay 1.203,67, but it becomes 0,00



I added the following display pattern: zzz,zz9.99



It works fine for case 2) and 3).

For the other cases it displays 0,00.



What is the right pattern to obtain 1), 2), 3) and 4)?



Kind regards.
0 Replies