decimalFormat
Syntax
decimalFormat(X, format)
Arguments
X is a scalar/vector of integers or floating numbers.
format is a string indicating the format to apply to X.
Details
Apply a specified format to the given object. The result is a string scalar/vector.
Symbol |
Meaning |
Notes |
---|---|---|
0 |
mandatory digit |
note 1 |
# |
optional digit |
note 2 |
. |
decimal point |
|
% |
percent sign |
note 3 |
E |
separates mantissa and exponent in scientific notation. |
note 4 |
, |
grouping separator |
note 5 |
; |
separates the format for positive numbers and the format for negative numbers |
note 6 |
Note 1: The number of 0s before the decimal point means the minimum number of digits before the decimal point. In comparison, the number of 0s after the decimal point means the number of digits after the decimal point.
$ decimalFormat(123,"0");
123
$ decimalFormat(123,"00000");
00123
$ decimalFormat(123.45,"0");
123
$ decimalFormat(123.45,"0.0");
123.5
$ decimalFormat(123.45,"0.000");
123.450
$ decimalFormat(123.45, ".0");
123.5
$ decimalFormat(0.45, ".0");
.5
Note 2: If 0s and #s are used together after the decimal point, 0s must appear before #s.
$ decimalFormat(123.45,"0.#");
123.5
$ decimalFormat(123.45,"0.###");
123.45
$ decimalFormat(123.456,"0.000###");
123.456
$ decimalFormat(123.456789110,"0.000###");
123.456789
$ decimalFormat(0.345, ".##");
.35
Note 3: % is always at the end of a format. % and E cannot both appear in a format.
$ decimalFormat(0.125,"0.00%");
12.50%
$ decimalFormat(0.125, "#.##%");
12.5%
$ decimalFormat(0.12567,"#.##%");
12.57%
Note 4: “E” is followed by at least one 0 and 0s only.
$ decimalFormat(1234567.89,"0.##E00");
1.23E06
$ decimalFormat(0.0000000000123456789,"0.000E0");
1.235E-11
Note 5: The grouping separator may only appear at most once in the parameter format. The number of digits between the grouping separator and the decimal point (if the decimal point is used) or the end of the format (if the decimal point is not used) determines the number of digits between grouping separators in the result.
$ decimalFormat(123456789,"#,###");
123,456,789
$ decimalFormat(123456789.166,"#,###.##");
123,456,789.17
$ decimalFormat(123456789.166,"0,000.00");
123,456,789.17
Note 6: If we prefer to apply different formats to an object depending on whether it is positive or negative, we can use “;” to seperate the 2 formats.
$ decimalFormat(123.456,"0.00#E00;(0.00#E00)");
1.235E02
$ decimalFormat(-123.456,"0.00#E00;(0.00#E00)");
(1.235E02)