Works: Date Serial Number and Display Are Incorrect (124517)



The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a

This article was previously published under Q124517

SYMPTOMS

A date entered into a Works spreadsheet or database may not register the correct date serial number and display incorrectly if the day is set to short (for example, Sun) instead of long (for example, Sunday) in the International Date Format setting in Control Panel.

  • With dates entered as "Month Day," for example, March 15, the day will interpreted as the year, in this case 1915.

  • With dates entered as "Month Day, Year," for example, March 15, 1995, the date will be interpreted as a text string.

STATUS

Microsoft has confirmed this to be a problem in the programs listed at the beginning of this article.

MORE INFORMATION


Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbhowto kbprb KB124517