XL2000: Wrong Date Saved to Clipboard (215175)
The information in this article applies to:
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 9/25/2003 |
|---|
| Keywords: | kbbug kbpending KB215175 |
|---|
|