dates get corrupted when copied to another workbook

Giganews Newsgroups
Subject: dates get corrupted when copied to another workbook
Posted by:  JimK
Date: Mon, 27 Oct 2003

I copy a worksheet in a workbook to a new workbook, a date of 10/13/03 becomes 10/22/99, off by 4 years and a day. A cell by cell copy has the same resuly. Never seen that before. I am using excel xp
anyone seen this before??

Replies