Name

FormatCurrency, FormatNumber, FormatPercent Functions

Class

Microsoft. VisualBasic. Strings

Syntax

FormatCurrency(expression[,NumDigitsAfterDecimal][, _
     IncludeLeadingDigit[,UseParensForNegativeNumbers[, _
     GroupDigits]]]]) 

FormatNumber(expression[,NumDigitsAfterDecimal][, _
     IncludeLeadingDigit[,UseParensForNegativeNumbers[, _
     GroupDigits]]]]) 

FormatPercent(expression[,NumDigitsAfterDecimal][, _
     IncludeLeadingDigit[,UseParensForNegativeNumbers[, _
     GroupDigits]]]])
expression

Use: Required

Data Type: Object

The number or numeric expression to be formatted.

NumDigitsAfterDecimal

Use: Optional

Data Type: Long

The number of digits the formatted string should contain after the decimal point.

IncludeLeadingDigit

Use: Optional

Data Type: TriState constant

Indicates whether the formatted string is to have a 0 before floating point numbers between 1 and -1.

UseParensForNegativeNumbers

Use: Optional

Data Type: TriState constant

Specifies whether parentheses should be placed around negative numbers.

GroupDigits

Use: Optional

Data Type: TriState constant

Determines whether digits in the returned string should be grouped using the delimiter specified in the computer’s regional settings. For example, on English language systems, the value 1000000 is returned as 1,000,000 if GroupDigits is True.

Return Value

String

Description

Functions used to format currency, numbers, and percentages.

The three functions are almost identical. They all take identical arguments. The only difference is that FormatCurrency ...

Get VB .NET Language in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.