ComponentOne True DBGrid for WinForms
Data Presentation Techniques / Text Formatting / Numeric Field Formatting / Predefined Numeric Options
In This Topic
    Predefined Numeric Options
    In This Topic

    The NumberFormat property has several possible predefined options for numeric and time and date values.

    For numeric data, the following predefined options are available in the NumberFormat property:

    Option Description
    Standard Display number with thousands separator, at least one digit to the left and two digits to the right of the decimal separator.
    General Number Display number as is, with no thousand separators.
    Currency Display number with thousands separator, if appropriate; display two digits to the right of the decimal separator. Note that output is based on system locale settings.
    Percent Display number multiplied by 100 with a percent sign (%) appended to the right; always display two digits to the right of the decimal separator.
    Fixed Display at least one digit to the left and two digits to the right of the decimal separator.
    Scientific Use standard scientific notation.
    Yes/No Display No if number is 0; otherwise, display Yes.
    True/False Display False if number is 0; otherwise, display True.
    On/Off Display Off if number is 0; otherwise, display On.
    0% Display number multiplied by 100, rounded to the nearest integer, with a percent sign (%) appended to the right.
    0.00% Same as Percent.

    For date and time data, the following predefined options are available in the NumberFormat property:

    Option Description
    General Date Display a date and/or time. For real numbers, display a date and time (for example, 4/3/93 05:34 PM); if there is no fractional part, display only a date (for example, 4/3/93); if there is no integer part, display only a time (for example, 05:34 PM). Date display is determined by your system settings.
    Long Date Display a date using your system's long date format.
    Medium Date Display a date using the medium date format appropriate for the language version of Visual Basic.
    Short Date Display a date using your system's short date format.
    Long Time Display a time using your system's long time format: includes hours, minutes, and seconds.
    Medium Time Display a time in 12-hour format using hours and minutes and the AM/PM designator.
    Short Time Display a time using the 24-hour format (for example, 17:45).
    See Also