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 Mid Func Rgb ❯

VBScript FormatNumber Function

The FormatNumber function returns an expression formatted as a number.

Syntax

Parameter Description
expression Required. The expression to be formatted.
NumDigAfterDec Optional. A numeric value indicating the number of digits to display to the right of the decimal point. The default is -1 (uses the computer's regional settings).
IncLeadingDig Optional. Indicates whether to display a leading zero for fractional 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 within 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 group symbols 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 of the above example:

Example 2

Setting the number of digits after the decimal point:

Output of the above example:

Example 3

Whether to display a leading zero for fractional values:

Output of the above example:

Example 4

Whether to place negative values within parentheses:

Output of the above example:

Example 5

Whether to group numbers:

Output of the above example:

❮ Func Mid Func Rgb ❯