Easy Tutorial
Func Monthname Func Strreverse Vb Func Now Func Ccur Func String Func Vartype Func Right Func Oct Func Timeserial Func Log Func Cint Func Sin Func Atn Func Formatcurrency Func Getref Func Tan Func Isarray Index Func Timer Func Strcomp Func Month Func Createobject Func Isdate Func Isnumeric Vbscript Summary Func Msgbox Func Eval Func Cbyte Func Isempty Func Join Func Formatdatetime Func Isnull Vb Func Dateadd Vbscript Tutorial Func Timevalue Func Getlocale Func Sgn Func Isobject Func Hex Func Int Func Lbound Func Day Func Cdbl Func Dateserial Func Split Func Sqr Vbscript Conditionals Func Cos Func Weekday Func Hour Func Rtrim Func Abs Func Ltrim Func Scriptengine Func Clng Func Trim Func Datevalue Func Cstr Vbscript Examples Vb Func Datepart Func Len Vb Func Array Func Asc Func Space Func Instr Vbscript Ref Functions Func Weekdayname Func Getobject Vb Func Datediff Func Fix Vbscript Ref Keywords Func Inputbox Func Typename Func Mid Func Formatnumber Func Rgb Func Second Func Cbool Func Instrrev Func Year Func Cdate Func Ubound Func Setlocale Func Rnd Func Replace Func Round Vb Func Date Func Exp Func Ucase Vbscript Procedures Func Formatpercent Vbscript Howto Func Left Func Minute Func Time Func Filter Func Lcase Func Csng Func Chr Vbscript Variables Vbscript Looping Func Loadpicture
❮ Func Atn Func Getref ❯

VBScript FormatCurrency Function

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

Syntax

Parameter Description
expression Required. The expression to be formatted.
NumDigAfterDec Optional. A numeric value indicating the number of digits to display after the decimal point. The default is -1 (uses the computer's regional settings).
IncLeadingDig Optional. Indicates whether to display a leading zero for decimal values: -2 = TristateUseDefault - Uses the computer's regional settings<br> -1 = TristateTrue - True <br> 0 = TristateFalse - False
UseParForNegNum Optional. Indicates whether to place negative values in parentheses: -2 = TristateUseDefault - Uses the computer's regional settings<br> -1 = TristateTrue - True <br> 0 = TristateFalse - False
GroupDig Optional. Indicates whether to group numbers using the digit grouping symbol specified in the computer's regional settings: -2 = TristateUseDefault - Uses the computer's regional settings<br> -1 = TristateTrue - True <br> 0 = TristateFalse - False

Example

Example 1

Output result of the above example:

Example 2

Setting the number of digits after the decimal point:

Output result of the above example:

Example 3

Displaying a leading zero for decimal values:

Output result of the above example:

Example 4

Placing negative values in parentheses:

Output result of the above example:

Example 5

Grouping a million dollars:

Output result of the above example:

❮ Func Atn Func Getref ❯