Article ID: 130049
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Office 97 Standard Edition
- Microsoft Office 95 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft PowerPoint 95 Standard Edition
- Microsoft Word 97 Standard Edition
- Microsoft Word 95 Standard Edition
This article was previously published under Q130049
SYMPTOMS
When you add a custom property of Date type to a document in one of the Microsoft Office programs listed at the beginning of this article, the property value may be displayed with a two-digit year, even if you enter the date with a four-digit year. For example, if you enter the value 1/1/1895, the value may be displayed as 1/1/95.
CAUSE
This behavior occurs if the Short Date Style value in the Regional Settings Properties dialog box is set to a two-digit year style. For example, if the Short Date Style box contains the value MM/dd/yy, when you enter a date value for a custom property, the date is displayed in this format, even if you enter the date in a four-digit year style.
Note that the date value is stored correctly, because it is stored as a time value instead of a string. For example, if you enter the value 1/1/1895, the year is stored correctly as 1895, even if the value is displayed as 1/1/95.
RESOLUTION
To display a custom Date type property in a four-digit year format, you can change the Short Date Format value by doing the following:
- On the taskbar, click Start. On the Settings menu, click Control Panel.
- Double-click the Regional Settings icon. Click the Date tab.
- In the Short Date Style list, click a style that has a 4-digit year, such as M/d/yyyy or MM/dd/yyyy.
- Click OK, and then close the Control Panel.
Additional query words: ppt95 ppt97 off97 xl97 8.00
Keywords: KB130049