format number()
This function converts a numeric value a into a string using the format template b and the optional locale c.
Parameters
|
Parameter |
Description |
|
a |
Numerical value. |
|
b |
Format template (Java text format). |
|
c |
(optional) Locale. Default: en_US. Note: Use the three dots to select a value. |
Examples
|
Parameter a |
Parameter b |
Parameter c |
Result |
|
1 |
#.000 |
|
1.000 |
|
1 |
#.000 |
en_US |
1.000 |
|
1 |
#.000 |
de_DE |
1,000 |
|
1234 |
#,###.00 |
|
1,234.00 |
|
1234 |
#,###.00 |
de_DE |
1.234,00 |