Num#() converts a text string to a numerical value, in the number format set in the load script or the operating system, unless a format string is supplied. Custom decimal and thousand separator symbols are optional parameters.
Syntax:
Num#(text[, format[, dec_sep [, thou_sep ] ] ])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| text |
The text string to be evaluated. |
| format | String describing how the resulting date string is to be formatted. If omitted, the number format set in the operating system is used. |
| dec_sep | String specifying the decimal number separator. If omitted, the MoneyDecimalSep value set in the load script is used. |
| thou_sep | String specifying the thousands number separator. If omitted, the MoneyThousandSep value set in the load script is used. |
The examples below assume the two following operating system settings:
- Number format default setting 1: # ##0
- Number format default setting 2: #,##0
Example:
Num#( A, '#.#', '.' , ',')
where A=35,648.375
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: |
35,648.375 |
35,648.375 |
| Number: |
35648.375 |
35648.375 |
