number-to-string(number a,(b,c,d,e,[f]))
|
Group |
Returns a formatted string of a number a using the formatting options b to e. If f is set, the number will be interpreted to be of radix f. If a radix (other than 10) is set, only Integers are accepted but the number of digits after the decimal separator is considered nonetheless.
With radix 16, the function can be used as decimal/hexadecimal converter and with radix 2 as decimal/binary converter.
Description of Parameters
|
Parameter |
Description |
|
a |
Number. |
|
b |
Thousand separator. |
|
c |
Decimal separator. |
|
d |
Number of digits per thousand. |
|
e |
Number of decimals. |
|
f |
Radix. Default: 10. |
Examples
|
Parameter a |
Parameter b |
Parameter c |
Parameter d |
Parameter e |
Parameter f |
Result |
|
12345678.6789 |
. |
, |
3 |
2 |
12.345.678,67 |
|
|
12345678.6789 |
' |
, |
2 |
2 |
12'34'56'78,67 |
|
|
255 |
: |
2 |
16 |
ff |
||
|
255 |
- |
4 |
2 |
1111-1111 |
||
|
831486 |
: |
2 |
16 |
c:af:fe |