I'm working on 2 xls Excel 2000 files (with all Office Updates and Windows
Updates applied on this WinXP PC). I'm copying a date from a cell in A.XLS
and pasting it into B.XLS. Both cells are formatted as dates. I copy the
1/1/1999 from A.XLS but when I paste it into B.XLS, it shows up as 1/1/1994.
There are NO formulas involved and I have auto-calculation ON. They are not
text, they are true date entries.
I've never seen anything like this and wouldn't know where to look for help
on this except for here.
Any suggestions greatly appreciated.
-Rob
Bookmarks