1. Home

VBScript FormatCurrency Function

The FormatCurrency function returns an expression formatted as a currency value using the currency symbol defined in the computer's control panel."

Examples

Example 1

<%

response.write(FormatCurrency(20000))

%>

The output of the code above will be:

$20,000.00

Example 2

Setting number of decimals:

<%

response.write(FormatCurrency(20000,2) & "<br />")
response.write(FormatCurrency(20000,5))

%>

The output of the code above will be:

$20,000.00
$20,000.00000

Example 3

Fractional values with or without a leading zero:

<%

response.write(FormatCurrency(.20,,0) & "<br />")
response.write(FormatCurrency(.20,,-1))

%>

The output of the code above will be:

$.20
$0.20

Example 4

Negative values inside parentheses or not:

<%

response.write(FormatCurrency(-50,,,0) & "<br />")
response.write(FormatCurrency(-50,,,-1))

%>

The output of the code above will be:

-$50.00
($50.00)

Example 5

Grouping a million dollars - or not:

<%

response.write(FormatCurrency(1000000,,,,0) & "<br />")
response.write(FormatCurrency(1000000,,,,-1))

%>

The output of the code above will be:

$1000000.00
$1,000,000.00

❮ Complete VBScript Reference

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US