Format Property

Gets or sets field’s format code. Keep it null (Nothing in Visual Basic) to select format automatically based on the data.

Syntax

'Declaration
 
Public Property Format As String

public string Format {get; set;}

Field format code.

Remarks

A subset of Microsoft Excel's format codes is supported. For more information follow this link: Number format codes.

0.############### - number format with default number of places before and after decimal separator. Number of '#' characters must be equal to 15.
00000.0000 - number format with specified number of places before and after decimal separator. In this particular example number will have at least 5 places before decimal separator and exactly 4 after it.
0 - number format with default number of places before decimal separator and no places after it.
#,0 - simply add '#,' in front of a number format code to show thousand separator.
0% - percentage format. Just put '%' sign after any supported number format.
$0 - currency format. '£' and '€' are also supported. Just put a currency sign in front of any supported number format.
mm/dd/yyyy - the only available date format.
mm/dd/yyyy h:mm AM/PM - the only available date and time format.
h:mm AM/PM - the only available time format.
0 (000) 000-0000 - phone format. Supported for both string and number field types.
@ - string format. Supported only for string field type.