Knowledge Base |

# Works: Date Serial Number and Display Are Incorrect

Article ID: 124517

Article Last Modified on 11/15/2004

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

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a kbhowto w_works wrong view form list incorrect register

Keywords: kbhowto kbprb KB124517