Microsoft KB Archive/42338

Mac Works: Available Date Formats and Entering Different Formats

PSS ID Number: Q42338 Article last modified on 10-22-1998

2.0 3.0 4.0

MACINTOSH

=
=========================================================

= SUMMARY =

The Microsoft Works Spreadsheet and Database modules store all dates as serial numbers. You can display these serial numbers in the following formats:

Works Version Format Dates ———————————————————–

2.0 Short 1/1/89 2.0 Medium Jan 1, 1989 2.0 Medium with weekday Sun, Jan 1, 1989 2.0 Long January 1, 1989 2.0 Long with weekday Sunday, January 1, 1989 3.0 & 4.0 Short 1/1/93 3.0 & 4.0 Month,Year Jan, 1993 3.0 & 4.0 Day, Month 1, Jan 3.0 & 4.0 Medium with weekday Fri, 1 Jan, 1993 3.0 & 4.0 Long 1 January, 1993 3.0 & 4.0 Long Friday, 1 January, 1993 3.0 & 4.0 Long January 1, 1993 3.0 & 4.0 Long Friday, January 1, 1993 3.0 & 4.0 Medium with weekday Fri, Jan 1, 1993 3.0 & 4.0 Medium without weekday Jan. 1, 1993

= MORE INFORMATION =

To format a date in a nonstandard format (such as a mm-dd-yy), you must format it as a text string. To enter a date as a text string, place a quotation mark (&quot;) before the date, as in the following example:

&quot;1-11-89

When you look at the date in the menu bar, the date is displayed with the quotation mark. However, in the cell, the date is displayed without the quotation mark.

= MORE INFORMATION =

NOTE: If you enter the date as text, Works will not generate a corresponding serial number for that date.

For more information about entering dates as text:


 * see page 321 of the version 4.0 “Microsoft Works User’s Guide”
 * see page 173 of the version 3.0 “Microsoft Works User’s Guide”
 * see page 214 of the version 2.0 “Using Microsoft Works” manual

For more information on entering dates and times:


 * see page 322 of the version 4.0 “Microsoft Works User’s Guide”
 * see page 175 of the version 3.0 “Microsoft Works User’s Guide”
 * see page 280 of the version 2.0 “Using Microsoft Works” manual

KBCategory: kbusage KBSubcategory: macworkskb

Additional reference words: 2.00 3.00 mwksss mwksdb

=
========================================================= Version : 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.