# 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

### WEB HOSTING

UK Reseller Hosting

### WEB BUILDING

FREE Website BUILDER Free HTML5 Templates

### W3SCHOOLS EXAMS

HTML, CSS, JavaScript, PHP, jQuery, XML, and ASP Certifications

### SHARE THIS PAGE

### Color Picker

### HTML/CSS

HTML Tutorial HTML5 Tutorial CSS Tutorial CSS3 Tutorial Bootstrap Tutorial

### JavaScript

JavaScript Tutorial jQuery Tutorial jQuery Mobile Tutorial AngularJS Tutorial AJAX Tutorial JSON Tutorial

### Graphics

Canvas Tutorial SVG Tutorial Google Maps Tutorial

### Server Side

SQL Tutorial PHP Tutorial ASP Tutorial ASP.NET Tutorial VBScript Tutorial AppML Tutorial

### Web

Web Building Web Statistics Web Certification

### XML

XML Tutorial DTD Tutorial Schema Tutorial XML DOM Tutorial XPath Tutorial XSLT Tutorial XQuery Tutorial XSL-FO Tutorial RSS Tutorial WSDL Tutorial

### HTML/CSS

HTML Tag Reference HTML Event Reference HTML Color Reference CSS 1,2,3 Reference Bootstrap Reference

### JavaScript

JavaScript Reference HTML DOM Reference jQuery Reference jQuery Mobile Reference Google Maps Reference

### Server Side

PHP Reference SQL Reference ASP Reference VBScript Reference Razor Reference ASP.NET Reference

### XML

XML DOM Reference XSLT Reference XSL-FO Reference XPath Reference XQuery Reference Schema Reference RSS Reference SVG Reference

### HTML Charsets

HTML Character Sets HTML ASCII HTML ANSI HTML Windows-1252 HTML ISO-8859-1 HTML Symbols HTML UTF-8

### HTML/CSS

HTML Examples CSS Examples

### Browser Scripting

JavaScript Examples HTML DOM Examples jQuery Examples jQuery Mobile Examples AngularJS Examples AJAX Examples

### Server Scripting

PHP Examples ASP Examples VBScript Examples Razor Examples .NET Examples

### XML Languages

XML Examples DTD Examples XML DOM Examples XSL Examples XSLT Examples XPath Examples XQuery Examples Schema Examples RSS Examples SVG Examples