Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Four-Digit Years May Display Only Two Digits


View products that this article applies to.

This article was previously published under Q237342

↑ Back to the top


Symptoms

When you open a Microsoft Excel workbook, cells that you had previously formatted to display four-digit years may now display two-digit years. This behavior occurs even if you had previously used the Date Fix Wizard to change all date formats in your workbook to display four-digit years.

↑ Back to the top


Cause

This behavior occurs when either of the following conditions is true:
  • The Short date style setting on the Date tab (under Regional Settings in Control Panel) has changed.

    -or-

  • Another user who has a different Short date style setting has saved changes to the workbook.
When you edit a workbook on a different computer with a different Short date style setting, Excel may change the format that it uses to display date values. This allows Excel to seamlessly convert date formats when you share your workbooks with people who are using different regional settings. This behavior is by design of Microsoft Excel.

↑ Back to the top


Workaround

To prevent this behavior from impacting the use of your workbooks, everyone who opens your workbook must have the same Short date style setting under Regional Settings in Control Panel.

↑ Back to the top


More information

The following steps illustrate how to reproduce this behavior.

NOTE: These steps assume that the current Short date style setting on your computer is M/d/yy.
  1. Save and close any open workbooks and then open a new workbook.
  2. Type the following date into cell A1:
    9/7/1999
    By default, the date is displayed as 9/7/99.
  3. Select cell A1 and then click Cells on the Format menu. In the Category list, click Date. In the Type list, click 3/14/1998 and then click OK.

    The date in cell A1 is now displayed as 9/7/1999.
  4. Save, and then close the file.
  5. Click Start, point to Settings, and then click Control Panel.
  6. Double-click the Regional Settings icon.
  7. On the Date tab, click M/d/yyyy in the Short date style list and then click OK.
  8. Switch to Excel. Open the file that you saved in step 4.

    The date in cell A1 is still displayed as 9/7/1999.
  9. Save, and then close the file.
  10. Click Start, point to Settings, and then click Control Panel.
  11. Double-click the Regional Settings icon.
  12. On the Date tab, click M/d/yy in the Short date style list and then click OK.

    The Short date style setting is now back to its default value.
  13. Switch to Excel.
  14. Open the file that you last saved in step 9.

    The date in cell A1 is now displayed as 9/7/99.

↑ Back to the top


References

For additional information about the Date Fix Wizard, please click the article number below to view the article in the Microsoft Knowledge Base:
176943� XL: Year 2000 Wizards for Microsoft Excel 97 and 2000 Available for Download

↑ Back to the top


Keywords: KB237342, kbprb

↑ Back to the top

Article Info
Article ID : 237342
Revision : 3
Created on : 10/6/2003
Published on : 10/6/2003
Exists online : False
Views : 232