This data converter reformats a number. The input text must be a number in the standard number format, e.g. "12378.64".
Note: If a number should be converted to the standard number format, use the Extract Number data converter.
The Format Number data converter is configured using the following properties:
The format pattern provides a very flexible way of specifying the number format. However, the rules for specifying the pattern can be somewhat difficult to understand, so simply find the default pattern that matches the required format best, and then experiment with changing that default pattern.
In a pattern, the following special characters can be used:
Special Character | Meaning |
---|---|
0 | A digit. |
# | A digit, but zero is not shown. |
. | The decimal separator, i.e. the character specified in the Decimal Separator field. |
, | The thousands separator, i.e. the character specified in the Thousands Separator field. |
- | The minus sign, i.e. the character specified in the Minus Sign field. |
E | In scientific notation, separates the mantissa and the exponent. |
Note that in the pattern, the '.' character is always used to select the decimal separator, regardless of what have been entered in the Decimal Separator field. The '.' character will then be replaced by the character in the Decimal Separator field when the number is formatted. The same applies to the thousands separator and minus sign.
Separate patterns can be specified for positive and negative numbers. This is done by specifying two patterns separated by semicolon (';'). For example, the pattern "#,##0.00;(#,##0.00)" can be used if negative numbers should be parenthesized instead of the default where the minus sign character is placed in front of negative numbers.