VBScript FormatNumber Function
Complete VBScript Reference
The FormatNumber function returns an expression formatted as a number.
Syntax
FormatNumber(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
<%
response.write(FormatNumber(20000))
%>
The output of the code above will be:
20,000.00
Show Example »
Example 2
Setting number of decimals:
<%
response.write(FormatNumber(20000,2) & "<br />")
response.write(FormatNumber(20000,5))
%>
The output of the code above will be:
20,000.00
20,000.00000
Show Example »
Example 3
Fractional values with or without a leading zero:
<%
response.write(FormatNumber(.20,,0) & "<br />")
response.write(FormatNumber(.20,,-1))
%>
The output of the code above will be:
.20
0.20
Show Example »
Example 4
Negative values inside parentheses or not:
<%
response.write(FormatNumber(-50,,,0) & "<br />")
response.write(FormatNumber(-50,,,-1))
%>
The output of the code above will be:
-50.00
(50.00)
Show Example »
Example 5
Grouping numbers - or not:
<%
response.write(FormatNumber(1000000,,,,0) & "<br />")
response.write(FormatNumber(1000000,,,,-1))
%>
The output of the code above will be:
1000000.00
1,000,000.00
Show Example »
Complete VBScript Reference
Color Picker