Solved Why are dates different when copied from Exce

August 12, 2011 at 03:56:20
Specs: Windows 7
I have to copy some dates from an excel 2010 workbook to a 2007 workbook. But the dates change when I do it. For example 30th November 1994 in 2010 becomes 29th November 1990 in 2007. I have made sure that the regional settings are the same in both files but that does not help. Can anyone help? The 2010 workbook was copied from a 32 bit Windows XP OS. The 2007 workbook is on a 64 bit Windows 7 OS.

See More: Why are dates different when copied from Exce

Report •

August 12, 2011 at 06:56:10
✔ Best Answer
Everything you ever wanted to know about this issue can be found right here:

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question