Copying a column of dates to another workbook
Posted by Linda on August 20, 1999 2:17 PM
Help! I'm trying to copy a column of dates from one Excel
workbook to another. The dates change by about 4 years in
the new workbook.
For example, I entered today's date, 8/20/99 in workbook A.
When I copied it to workbook B, the date shows as 8/21/03.
However, if I enter 8/20/99 in workbook B and copy it to A,
it displays as 8/19/95. What gives? Short of converting
each date to Text format, is there any way to copy dates
between workbooks and get the real date??