Mask - Number & Currency tab - Field Properties
The mask format is in the format LZ.ND;$PF;$NF;DS;TS;SY where:
| Code |
Representation |
| LZ |
Leading Zeros. Enter a 0 for a leading zero. Leave empty for NONE. |
| ND |
Number of Decimals; specify the amount of decimals in zeros or leave empty. |
| PF |
Positive number Format where $ is a placeholder for a symbol. |
| NF |
Negative number Format where $ is a placeholder for a symbol. |
| DS |
Decimal Separator. |
| TS |
Thousands Separator. |
| SY |
Symbol. |
Examples
| Mask |
Explanation |
0.00;$1.1;($1.1);,;.;€ |
formats a number as currency with 2 decimals, negative values between parentheses, a comma as decimal separator, and a dot as thousands separator. The currency symbol is a € (euro) character. |
| Value |
Result |
| 123.45 |
€123,45 |
| 3457.89 |
€3.457,89 |
| 0.35 |
€0,35 |
| -123.45 |
(€123,45) |
| Mask |
Explanation |
.00;1.1$;(1.1$);.;,;$ |
a number will be formatted s currency with 2 decimals, no leading zeroes, negative values between parentheses, a dot as decimal separator, and a comma as thousands separator. The currency symbol is a US dollar character. |
| Value |
Result |
| 123.45 |
123.45$ |
| 3457.89 |
3,457.89$ |
| 0.35 |
.35$ |
| -123.45 |
(123.45$) |
Notes