Microsoft KB Archive/76573

= Works: Dates Displayed as Numbers in Database or Spreadsheet =

Article ID: 76573

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q76573



SUMMARY
Works stores dates as a numeric serial number. The starting day is January 1, 1900. If a field or cell where a date has been entered displays a number, this number represents the number of days since January 1, 1900.



MORE INFORMATION
When entering a date in a spreadsheet or a database and if the date appears as a number, use the following methods to make the date appear in date format. Although you can try these methods in any order, the first method addresses the most common cause.

Works 4.0, 4.5, 4.5a for Windows 95

 * 1) In the Works spreadsheet, select the column with the incorrect date.

In the Works database, either click on the field with the incorrect date or use the ARROW keys to move to the field with the incorrect date.
 * 1) On the Format menu in the spreadsheet, click Number.

In the Works database, on the Format menu, click Field.
 * 1) In the Format box, click Date.
 * 2) Select the appropriate Date format and click OK.

Works 3.0

 * 1) In the Works spreadsheet, select the column with the incorrect date.

In the Works database, either click on the field with the incorrect date or use the ARROW keys to move to the field with the incorrect date.
 * 1) From the Format menu, click Number and Date/Time.
 * 2) Select the appropriate Date/Time format.
 * 3) Click OK or press ENTER.

Works 2.0

 * 1) In the Works spreadsheet, select the column with the incorrect date

In the Works database, either click on the field with the incorrect date or use the arrow keys to move to the field with the incorrect date.
 * 1) Format the column as Time/Date.
 * 2) Select the desired format and press ENTER.

NOTE: In some cases, the date will not display properly, even though method 1 above was properly executed. If the date still does not display properly, try the following method.

Windows 95

 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click Regional Settings. Click the Date tab.

Make sure that the appropriate date format is defined for the Country and Language selected.

Windows 3.0
Run the Windows Control Panel and double-click the International icon. Make sure that the appropriate date format is defined for the Country and Language selected.

