FUNCTION: FormatCurrency( )
Implemented in version 2.0
FormatCurrency(Expression,
NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers,
GroupDigit)
The FormatCurrency function return a formatted currency value
for the numeric expression.
There is one mandatory argument.
Expression
The Expression argument is the number to be converted to a
currency format.
Code:
<% =FormatCurrency(31567) %>
Output:
$31,567.00
Note that this function rounds off values.
Code:
<% =FormatCurrency(31567.8977) %>
Output:
$31,567.90
There are 4 optional arguments.
NumDigitsAfterDecimal
The optional NumDigitsAfterDecimal argument allows you
to choose the number of digits after the decimal.
Code:
<% =FormatCurrency(31567, 2) %>
Output:
$31,567.00
IncludeLeadingDigit
The optional IncludeLeadingDigit argument includes the
leading zero.
You must only use the constant or value from the Tristate CONSTANTS
for this argument.
| CONSTANT |
VALUE |
DESCRIPTION |
| TristateTrue |
-1 |
True, will
use options |
| TristateFalse |
0 |
False, will
not use options |
| TristateUseDefault |
-2 |
Use default
setting |
|
Code:
<% =FormatCurrency(.77, 2, -1) %>
Output:
$0.77
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
for this argument.
| CONSTANT |
VALUE |
DESCRIPTION |
| TristateTrue |
-1 |
True, will
use options |
| TristateFalse |
0 |
False, will
not use options |
| TristateUseDefault |
-2 |
Use default
setting |
|
Code:
<% =FormatCurrency(-31567, 2, 0, -1) %>
Output:
($31,567.00)
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
for this argument.
| CONSTANT |
VALUE |
DESCRIPTION |
| TristateTrue |
-1 |
True, will
use options |
| TristateFalse |
0 |
False, will
not use options |
| TristateUseDefault |
-2 |
Use default
setting |
|
Code:
<% =FormatCurrency(31567, 2, 0, -1, -1) %>
Output:
$31,567.00
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
|