Money() formats an expression numerically as a money value, in the format set in the system variables set in the data 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.