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
|
Example 1
document.write(FormatNumber(20000))
Output:
20,000.00
|
Example 2
document.write(FormatNumber(20000.578,2))
Output:
20,000.58
|
Example 3
document.write(FormatNumber(20000.578,2,,,0))
Output:
20000.58
|
Complete VBScript Reference
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
