VBScript » Functions » FormatNumber
Version: 2.0
- Syntax:
- FormatNumber(Expression, NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers, GroupDigit)
- Expression
- The Expression argument is the number to be converted to a formatted number.
- NumDigitsAfterDecimal
- The optional NumDigitsAfterDecimal argument allows you to choose the number of digits after the decimal.
- IncludeLeadingDigit
- The optional IncludeLeadingDigit argument includes the leading
zero.
You must only use the constant or value from the Tristate Constants table for this argument. - UseParensForNegativeNumbers
- The optional UseParensForNegativeNumber argument replaces a
negative sign with parentheses around the number.
You must only use the constant or value from the Tristate Constants table for this argument. - GroupDigit
- The optional GroupDigit argument allows the use of the options
specified in the Regional Settings Properties in the Control Panel to
display a number.
You must only use the constant or value from the Tristate Constants table for this argument.
The FormatNumber function return a formatted number value for
the numeric expression.
Tristate Constants
| CONSTANT | VALUE | DESCRIPTION |
|---|---|---|
| TristateTrue | -1 | True, will use options |
| TristateFalse | 0 | False, will not use options |
| TristateUseDefault | -2 | Use default setting |
Examples
Code:
<% =FormatNumber(12345) %>Output:
12,345.00Language(s): VBScript
Code:
<% =FormatNumber(12345.67899) %>Output:
12,345.68Language(s): VBScript
Code:
<% =FormatNumber(12345.67899, 4)
%>Output:
12,345.6790Language(s): VBScript
Code:
<% =FormatNumber(.77, 4, -1) %>Output:
0.7700Language(s): VBScript
Code:
<% =FormatNumber(-12345.67899, 2, 0, -1)
%>Output:
(12,345.68)Language(s): VBScript
Code:
<% =FormatNumber(12345.67899, 2, 0, -1, -1)
%>Output:
12,345.68Language(s): VBScript
See Also:
