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
|
Examples
Example 1
<script type="text/vbscript">
document.write(FormatCurrency(20000))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 2
Setting number of decimals:
<script type="text/vbscript">
document.write(FormatCurrency(20000,2) & "<br />")
document.write(FormatCurrency(20000,5))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 3
Fractional values with or without a leading zero:
<script type="text/vbscript">
document.write(FormatCurrency(.20,,0) & "<br />")
document.write(FormatCurrency(.20,,-1))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 4
Negative values inside parentheses or not:
<script type="text/vbscript">
document.write(FormatCurrency(-50,,,0) & "<br />")
document.write(FormatCurrency(-50,,,-1))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 5
Grouping a million dollars - or not:
<script type="text/vbscript">
document.write(FormatCurrency(1000000,,,,0) & "<br />")
document.write(FormatCurrency(1000000,,,,-1))
</script>
|
The output of the code above will be:
$1000000.00
$1,000,000.00 |
Try it yourself »
|
Complete VBScript Reference
Whether you're new to XML or already an advanced user, the user-friendly views and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to meet your XML and Web development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- 32-bit and 64-bit versions
- And much more!
Download a free trial today!
|
|
|
|
