VBScript FormatNumber Function

## VBScript Tutorial

VB HOME VB How to VB Variables VB Procedures VB Conditional VB Looping VB Summary

## VB Examples

VB Examples

## VB References

VB Functions VB Keywords

# 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:

20,000.00
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:

20,000.00
20,000.00000
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:

.20
0.20
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:

-50.00
(50.00)
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:

1000000.00
1,000,000.00
Try it yourself »

Complete VBScript Reference

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE