XL2000: Wrong Date Saved to Clipboard

• Microsoft Excel 2000

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 this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000 parse date paste lose year years copy copied incorrect y2k

Keywords : kbdta kb2000 xlformat
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug