See our in-depth usage of Scaling/Alignment, with examples here : Specifies the characters to be appending to the numeric content of the field.Ĭharacters can be optionally removed when the content of the field matches the specified criteria.Įxample using Remove - Remove ".00" from numbers over 99. The field will be prefixed with the euro symbol. Specifies the characters to be inserted before the numeric content of the field. Values will be formatted to two decimal places. Specifies the number of digits that will appear after the decimal point. Values greater than a thousand will use a comma as a thousands separator.
The thousands separator is used to divide the value into groups of three, right-to-left from the decimal point. Specifies a character or characters to use to as the thousands separator. Specifies the decimal separator (radix point) character(s) to use. The position "*" character specifies that a minimum of 2 decimal places are required. No decimal point is provided in the format string, therefore the value will appear as a whole number.Ĥ places are available after the decimal point - the output value is truncated, not rounded.Īs the characters "USD" do not have any special meaning, they appear untranslated in the output.
The comma may be used to separate groups of digits. Only 2 positions are available after the decimal point. Used after the decimal point, the * character indicates the minimum number of characters that must appear.įor example, you can specify that a field must appear with at least two decimal places, but more will be output if required. May or may not be present as a divider between groups of digits, such as thousands, millions, etc. No rounding will be performed on the value. Specifies where the decimal point should appear and, by the use of the # character after the point, how many decimal places the number should be formatted to. The # character indicates where digits from the source field should appear. The two formatting strings are separated by a semi-colon ( ). A formatting string should be defined for when the field contains a positive number and a negative number.
0 kommentar(er)
