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
<script type="text/vbscript">
document.write(FormatNumber(20000))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 2
Setting number of decimals:
<script type="text/vbscript">
document.write(FormatNumber(20000,2) & "<br />")
document.write(FormatNumber(20000,5))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 3
Fractional values with or without a leading zero:
<script type="text/vbscript">
document.write(FormatNumber(.20,,0) & "<br />")
document.write(FormatNumber(.20,,-1))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 4
Negative values inside parentheses or not:
<script type="text/vbscript">
document.write(FormatNumber(-50,,,0) & "<br />")
document.write(FormatNumber(-50,,,-1))
</script>
|
The output of the code above will be:
Try it yourself »
|
Example 5
Grouping numbers - or not:
<script type="text/vbscript">
document.write(FormatNumber(1000000,,,,0) & "<br />")
document.write(FormatNumber(1000000,,,,-1))
</script>
|
The output of the code above will be:
Try it yourself »
|
Complete VBScript Reference
Create a free Flash website with our simple, online web design editing platform. Stunning templates
and user-friendly tools make website building easy and fun.
Start Creating your free website now!
The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
