Predefined Date and Time Formats

The following table describes predefined date and time formats that you can use.

Format	Description
General Date	Note the following: If the number includes an integer part and a fractional part, then it displays date and time information. For example, 11/8/2011 1:23:45 PM. If the number includes only an integer part, then it displays this integer as a date. If the number includes only a fractional part, then it displays this fractional part as time.
Long Date	Displays a long date. The International section of the Control Panel defines a long date.
Medium Date	Displays the date using the month abbreviation without the day of the week. For example, 08-Nov-2011.
Short Date	Displays a short date. The International section of the Control Panel defines a short date.
Long Time	Displays a long time. The International section of the Control Panel defines a long time. It includes hours, minutes, and seconds.
Medium Time	Does not display seconds. It displays hours in a 12 hour format and uses the AM and PM designator.
Short Time	Does not display seconds. It uses a 24 hour format and does not use the AM and PM designator.