Format pour les dates :



General Date, or G
Displays a date and/or time. For example, 4/3/93 05:34 PM. Date display is determined by your system's LocaleID value.

Long Date, or D
Displays a date according to your locale's long date format.

Medium Date
Displays a date using the medium date format appropriate for the language version of the host application.

Short Date, or d
Displays a date using your locale's short date format.

Long Time, or T
Displays a time using your locale's long time format; includes hours, minutes, seconds.

Medium Time
Displays time in 12-hour format using hours and minutes and the AM/PM designator.

Short Time, or t
Displays a time using the 24-hour format, for example, 17:45.

f
Displays the long date and short time according to your locale's format.

F
Displays the long date and long time according to your locale's format.

g
Displays the short date and short time according to your locale's format.

M,m
Displays the month and the day of a date.

R,r
Formats the date and time as Greenwich Mean Time (GMT)

s
Formats the date and time as a sortable index.

u
Formats the date and time as a GMT sortable index.

U
Formats the date and time with the long date and long time as GMT.

Y, y
Formats the date as the year and month.

format pour les nombres :



General Number, G, or g
Displays number with no thousand separator.

Currency,C, or c
Displays number with thousand separator, if appropriate; display 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, orn
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, ore
Uses standard scientific notation, providing six significant digits.

D, ord
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, orx
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.