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. |