Microsoft KB Archive/215676

= XL2000: Page Formats in Header/Footer Use Two-Digit Year =

Article ID: 215676

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215676



SYMPTOMS
When you add a date to a header or footer, Microsoft Excel inserts the date as a two-digit year. There is no way to change this from within the Page Setup dialog box.



CAUSE
Excel uses the Short date style format specified under Regional Settings in Control Panel. If the Short date style format uses a two-digit year, you will see a two-digit year in a header or footer in Excel.



RESOLUTION
To use a four-digit year format in a header or footer in Excel, change the Short date style format. To do this, follow these steps:

 On the Start menu, point to Settings and then click Control Panel. Double-click the Regional Settings icon. Click the Date tab. In the Short date style box under Short Date, type or select a date format that uses four digits. For example, use one of the following formats:

M/d/yyyy

MM/dd/yyyy

 Click Apply. Click OK.

When you use a date format in a header or footer, it will be formatted using a four-digit year.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kbfix kbprb KB215676

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.