Decimal Format
The Decimal Format defines the format to use when storing decimal categories in the database. If a decimal format is not set, then the format string defaults to “0.00”.
The following format characters can be used when defining the decimal format setting.
Format Character | Name | Description |
|---|---|---|
0 | Zero Placeholder | If the value being formatted has a digit in the position where the '0' is in the format string, then that digit is copied to the result string. The position of the leftmost '0' before the decimal point and the rightmost '0' after the decimal point determines the range of digits that are always present in the result string. |
# | Digit Placeholder | If the value being formatted has a digit in the position where the '#' is in the format string, then that digit is copied to the result string. Otherwise, nothing is stored in that position in the result string. |
. | Decimal Point | The first '.' character in the format string determines the location of the decimal separator in the formatted value; any additional '.' characters are ignored. The actual character uses as the decimal separator in the result string and depends on the culture name. |
, | Thousand Separator | If the format string contains a ',' character between two digit placeholders (0 or #) and to the left of the decimal point if one is present, then the output will have thousand separators inserted between each group of three digits to the left of the decimal separator. The actual character utilizes as the group separator in formatted decimal values and depends on the culture name. |
Decimal Format String Examples:
0.00
00.000
#.00
0.0#
#,###.0