Export (0) Print
Expand All

Predefined Numeric Formats (Format Function)

The following table identifies the predefined numeric format names. These may be used by name as the style argument for the Format function:

Format name

Description

General Number, G, or g

Displays number with no thousand separator.

Currency, C, or c

Displays number with thousand separator, if appropriate; displays two digits to the right of the decimal separator. Output is based on system locale settings.

Fixed, F, or f

Displays at least one digit to the left and two digits to the right of the decimal separator.

Standard, N, or n

Displays number with thousand separator, at least one digit to the left and two digits to the right of the decimal separator.

Percent

Displays number multiplied by 100 with a percent sign (%) appended immediately to the right; always displays two digits to the right of the decimal separator.

P, or p

Displays number with thousandths separator multiplied by 100 with a percent sign (%) appended to the right and separated by a single space; always displays two digits to the right of the decimal separator.

Scientific

Uses standard scientific notation, providing two significant digits.

E, or e

Uses standard scientific notation, providing six significant digits.

D, or d

Displays number as a string that contains the value of the number in Decimal (base 10) format. This option is supported for integral types (Byte, Short, Integer, Long) only.

X, or x

Displays number as a string that contains the value of the number in Hexadecimal (base 16) format. This option is supported for integral types (Byte, Short, Integer, Long) only.

Yes/No

Displays No if number is 0; otherwise, displays Yes.

True/False

Displays False if number is 0; otherwise, displays True.

On/Off

Displays Off if number is 0; otherwise, displays On.

The Yes/No, True/False, and On/Off formats are not supported.

Namespace: Microsoft.VisualBasic

Module: Strings

Assembly: Visual Basic Runtime Library (in Microsoft.VisualBasic.dll)

Community Additions

ADD
Show:
© 2014 Microsoft