Numeric Mask Format¶
The mask format is in the format 'LZ.ND;NF;DS;TS' where:
| Code | Representation |
|---|---|
| LZ | Leading Zeros. Enter a 0 for a leading zero. Leave empty for NONE |
| ND | Number of Decimals; give the amount of decimals in zeros or leave empty |
| NF | Negative number Format |
| DS | Decimal Separator |
| TS | Thousands Separator |
Examples¶
With a mask ".000;(1.1);.;," a number will be formatted with 3 decimals, negative values between parentheses, a dot as decimal separator and a comma as thousands separator.
| Value | Result |
|---|---|
| 123.45 | 123.450 |
| -123.45 | (123.450) |
With a mask ".0000;1.1-;,;." a number will be formatted with 4 decimals, negative sign to the right, a comma as decimal separator and a dot as thousands separator.
| Value | Result |
|---|---|
| 123.45 | 123.4500 |
| -123.45 | 123.4500- |
Notes¶
- The double quotes in the example masks are needed when using the FormatNumber function and need to be omitted when used via the field properties dialog.