VBScript FormatCurrency Function
Complete VBScript Reference
The FormatCurrency function returns an expression formatted as a currency
value using the currency symbol defined in the computer's control panel.
Syntax
FormatCurrency(Expression[,NumDigAfterDec[,
IncLeadingDig[,UseParForNegNum[,GroupDig]]]])
|
Parameter |
Description |
expression |
Required. The expression to be formatted |
NumDigAfterDec |
Optional. Indicates how many places to the right of the
decimal are displayed. Default is -1 (the computer's regional settings are
used) |
IncLeadingDig |
Optional. Indicates whether or not a leading zero is
displayed for fractional values:
- -2 = TristateUseDefault - Use the computer's regional settings
- -1 = TristateTrue - True
- 0 = TristateFalse - False
|
UseParForNegNum |
Optional. Indicates whether or not to place negative
values within parentheses:
- -2 = TristateUseDefault - Use the computer's regional settings
- -1 = TristateTrue - True
- 0 = TristateFalse - False
|
GroupDig |
Optional. Indicates whether or not numbers are grouped
using the group delimiter specified in the computer's regional settings:
- -2 = TristateUseDefault - Use the computer's regional settings
- -1 = TristateTrue - True
- 0 = TristateFalse - False
|
Example 1
document.write(FormatCurrency(20000))
Output:
$20,000.00
|
Example 2
document.write(FormatCurrency(20000.578,2))
Output:
$20,000.58
|
Example 3
document.write(FormatCurrency(20000.578,2,,,0))
Output:
$20000.58
|
Complete VBScript Reference
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an INSTANT DEMO or download a FREE TRIAL today. |
|
|
|