Numeric type format
Numeric type format specifies the alphanumeric formats in which numbers can be displayed in Smile. These formats specify display configurations for presenting currency, including debit and credit, decimal places and the use of other notations such as commas, brackets and other characters.
Attention: The numeric type format is specified in Java's notation so the decimal
place is always a period and the thousands separator is always a comma in the format string. If
your localisation uses other characters for these notations then you need to have the correct
localisation set in Smile. When viewing individual format string configuration in Smile the
examples displayed will use your localisation. For more information, contact Inomial.
| Format | Description | Example |
|---|---|---|
| # | Specifies a single numeric placeholder at the start or end of a number. Will only display if a value exists. Enter multiple characters to specify longer numbers or decimal places. | ###0.00 |
| 0 | Specifies a single numeric placeholder. Will display the relevant value, otherwise will display 0. Enter multiple characters to specify longer numbers or decimal places. | 0.00 |
| . | Specifies a decimal point. Only one decimal point character can be specified in a numeric value. | |
| , | Specifies a comma break in numbers of four or more digits. | 1,000,000 |
| Letters, symbols, special characters | Specifies characters that are displayed before or after a numeric value. | -$(0.00) CR |
| decimal place length | Decimal place length is specified in the Positive Format field. This length will be used regardless of the length specified in the Negative Format or Zero Format fields. |
| Format | Result |
|---|---|
| 0.00 | 1.23 |
| ###0.0000 | 1234.5600 |
| $#,##0.00 CR | $1,234.56 CR |
| $(#,##0.00) | $(1,234.56) |
| -#,##0.00 | -1,234.56 |