JMP displays numbers as currency using the Format() function, which uses the following syntax:
•
|
x is a column or a number
|
•
|
"currency code" is an International Standards Organization (ISO) 4217 code
|
•
|
decimal is the number of decimal places
|
To illustrate the Format function:
To ignore the computer’s locale and use a period for the decimal separator, include the Use Locale(0) argument:
提示:If you change the region when JMP is open, restart JMP for the Use Locale setting to work properly.
Currencies Supported in JMP lists the currencies supported in JMP.
For details about how to format currency, see “Format(x, width|<width, decimal places>, <"Use thousands separator">)” the JSL Functions chapter in the JSL Syntax Reference.