Money() formats an expression numerically as a money value, in the format set in the system variables set in the load script, or in the operating system, unless a format string is supplied, and optional decimal and thousands separators.
Syntax:
Money(number[, format[, dec_sep[, thou_sep]]])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| number |
The number to be formatted. |
| format | String describing how the resulting money string is to be formatted. |
| dec_sep | String specifying the decimal number separator. |
| thou_sep | String specifying the thousands number separator. |
If arguments 2-4 are omitted, the currency format set in the operating system is used.
Examples:
The examples below assume the following default settings:
- MoneyFormat setting 1: kr ##0,00, MoneyThousandSep' '
- MoneyFormat setting 2: $ #,##0.00, MoneyThousandSep','
Example 1:
Money(
A )
where
A=35648
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: | kr 35 648,00 | $ 35,648.00 |
| Number: | 35648.00 | 35648.00 |
Example 2:
Money(
A, '#,##0 ¥', '.' , ',' )
where
A=3564800
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: | 3,564,800 ¥ | 3,564,800 ¥ |
| Number: | 3564800 | 3564800 |
