VBScript » Functions » FormatCurrency
Version: 2.0
- Syntax:
- FormatCurrency(Expression, NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers, GroupDigit)
- Expression
- The Expression argument is the number to be converted to a currency format.
- NumDigitsAfterDecimal
- The optional NumDigitsAfterDecimal argument allows you to
choose the number of digits after the decimal.
- IncludeLeadingDigit
- The optional IncludeLeadingDigit argument includes the leading zero. You must only use the constant or value from the Tristate Constants table for this argument.
- UseParensForNegativeNumbers
- The optional UseParensForNegativeNumber argument replaces a
negative sign with parentheses around the number.
You must only use the constant or value from the Tristate Constants table for this argument. - GroupDigit
- The optional GroupDigit argument allows the use of the options
specified in the Currency tab in the Regional Settings Properties in
the Control Panel.
You must only use the constant or value from the Tristate Constants table for this argument.
The FormatCurrency function returns a formatted currency value
for the numeric expression. Note that this function rounds off values.
Tristate Constants
| CONSTANT | VALUE | DESCRIPTION |
|---|---|---|
| TristateTrue | -1 | True, will use options |
| TristateFalse | 0 | False, will not use options |
| TristateUseDefault | -2 | Use default setting |
Examples
Code:
<% =FormatCurrency(31567) %>Output:
$31,567.00Language(s): VBScript
Code:
<% =FormatCurrency(31567.8977) %>Output:
$31,567.90Language(s): VBScript
Code:
<% =FormatCurrency(31567, 2) %>Output:
$31,567.00Language(s): VBScript
Code:
<% =FormatCurrency(.77, 2, -1) %>Output:
$0.77Language(s): VBScript
Code:
<% =FormatCurrency(-31567, 2, 0, -1)%>Output:
($31,567.00)Language(s): VBScript
Code:
<% =FormatCurrency(31567, 2, 0, -1, -1)
%>Output:
$31,567.00Language(s): VBScript
See Also:
