Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











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-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information