W3Schools.com

VBScript FormatCurrency Function

VBScript Reference 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:

$20,000.00

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:

$20,000.00
$20,000.00000

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:

$.20
$0.20

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:

-$50.00
($50.00)

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 »
VBScript Reference Complete VBScript Reference
WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$7.95/mo SEO Hosting
Premium Website Design
WEB BUILDING
XML Editor - Free Trial!
FREE Website BUILDER
Free Website Templates Free CSS Templates
Make Your Own Website
W3SCHOOLS EXAMS
Get Certified in:
HTML, CSS, JavaScript, XML, PHP, and ASP
W3SCHOOLS BOOKS
New Books:
HTML, CSS
JavaScript, and Ajax
STATISTICS
Browser Statistics
Browser OS
Browser Display
SHARE THIS PAGE