| Format Name | Description |
| General Number | Display number with no thousand separator. |
| Currency | Display number with thousand separator, if appropriate; display two digits to the right of the decimal separator. Output is based on system locale settings. |
| Fixed | Display at least one digit to the left and two digits to the right of the decimal separator. |
| Standard | Display number with thousand separator, at least one digit to the left and two digits to the right of the decimal separator. |
| 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. |
| 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. |
| 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 time only, for example, 05:34 PM. Date display is determined by your system settings. |
| Long Date | Display a date according to your system's long date format. |
| Medium Date | Display a date using the medium date format appropriate for the language version of the host application. |
| 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, seconds. |
| Medium Time | Display 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. |
No comments:
Post a Comment