Currency Picture
Setup > Configuration > System > Advanced Options and Settings
To change the currency picture (display), select Setup > Configuration > System > Advanced Options and Settings.
It is very important to make sure you have a negative sign or parenthesis to specify negative values. If you fail to do so, negative numbers will display as positive numbers and errors can occur.
| Token | Meaning |
|---|
@N | Indicate a number |
~sign~ | Optional - Show a sign |
- | Optional - Show the negative sign to the left |
xx | Number of digits to left |
. | Decimal point |
xx | Number of digits to right |
~sign~ | Optional - Show the negative sign to the right |
| Dollar/Euro | Result | Format |
|---|
| @N$-14.2B | $-2,347.25 | Leading dollar sign, blank if zero |
| @N~€~-14.2B | €-2,347.25 | Leading Euro sign, blank if zero |
| @N$14.2- | $2,347.25- | Leading dollar sign, trailing minus when negative |
| @N$(14.2) | $(2,347.25) | Leading dollar sign, in parens when negative |
| @N-14 | 112,347 | Whole Number currency |
| Int'l Currency | Result | Format |
|---|
| @N~£~14.2 | £1,240.50 | United Kingdom |
@Nkr14'2 | kr1.430,50 | Norway |
| @N14_'2~ mk~ | 1 430,50 mk | Finland |
| @N14'2~ kr~ | 1.430,50 kr | Sweden |
Number Pictures
| Picture | Result |
|---|
| @N-13 | 1,123,456 |
| @N-13.2 | 1,234,456.10 |
| @N13.2- | 2,347.25- |
| @N(13.2) | (2,347.25) |