Number Formats
Number formats apply to the formatting of numbers, including currency amounts.
Symbols
You can use the following symbols to specify a number format:
0 | Placeholder for a mandatory digit. |
# | Placeholder for an optional digit. |
. | Placeholder for the decimal point. |
, | Placeholder for the thousands separator. |
% | Formats the value as a percentage. |
E | Placeholder for the exponent displayed in uppercase. |
e | Placeholder for the exponent displayed in lowercase. |
The exponent symbols “E” and “e” can be followed by a “+” or “-” sign. A “-” sign means that the exponent sign must be displayed only if it is negative. A “+” sign or no sign means that the sign of the exponent is always displayed.
When a “%” symbol appears in the format specification, the numeric value to be formatted is multiplied by 100 before formatting and a “%” symbol appears in the result.
“0” symbols are replaced by zeros when there is no corresponding digit in the number value.
Examples
Value | Format | Result |
|---|
1234.567 | #,##0.00 | 1 234.57 |
1234.567 | #,##0.0# | 1 234.57 |
1234.5 | #,##0.00 | 1 234.50 |
1234.5 | #,##0.0 | 1 234.5 |
1.5 | 0,000.00 | 0 001.50 |
1234 | 0.00 E+00 | 1.23 E+03 |
1234 | 0.00 E-00 | 1.23 E03 |
1234 | 0.00 E-## | 1.23 E3 |
0.5432 | #.# % | 54.3 % |
The characters used to represent the decimal point and the thousands separator in the formatted result depend on application settings that can be changed. Typically, they depend on the country where the application is used. These settings do not affect the symbols used as placeholders for the decimal point and for the thousands separator in format specifications. You should thus always use the placeholders listed above for these values as only the output depends on the application settings.
Note that the maximum precision is 15 digits for double values and 7 for float values.
Published date: 05/24/2022
Last modified date: 02/24/2022
