FormatCurrency
This function formats a string as a currency for the specified locale.
Arguments
FormatCurrency(1,2,3,4)
Ordinal | Type | Required | Description |
---|---|---|---|
1 | String | True | Currency string to format |
2 | String | True | ISO locale code for the currency unit |
3 | Number | False | Decimal places to include in the output |
4 | String | False | Currency symbol for output. This overrides the currency symbol specified by the ISO locale code |
NOTE: By default, this function rounds half up to two decimal places.
Example 1
Output
Example 2
Not a subscriber? Subscribe now.
Example 3
Not a subscriber? Subscribe now.