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.