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)