Microsoft KB Archive/215175

= XL2000: Wrong Date Saved to Clipboard =

Article ID: 215175

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215175



SYMPTOMS
When you copy a date from one workbook and paste it into another workbook, the century in the pasted value is incorrect.



CAUSE
This problem occurs when the Short date style setting under Regional Settings in Control Panel is set to display two-digit years, or you have applied a two-digit date format to the cell, and you close the source workbook before pasting the date into another workbook.



WORKAROUND
To prevent this problem from occurring, verify the copied cell displays all four digits of the year, or leave the source workbook open until the paste operation has completed.



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 parse date paste lose year years copy copied incorrect y2k

Keywords: kbbug kbpending KB215175

-

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

© Microsoft Corporation. All rights reserved.