Thanks, This Solved My Issue.



"MESTRELLA29" wrote:

OK, How do I change This?

"Sandy Mann" wrote:

Looks to me like the 2007 Workbook is set to 1904 date system.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"MESTRELLA29" wrote in message
...
I have a File that contains data Dump from one data source (Not Excel) this
File is in Excel 2003 Vertion, this data has dates in Date format. MDY

When I copy and paste the data to a Excel 2007 File (Because it has cool
conditional formatting) the date that follow change:

Excel 2003 Data:
18-Nov-07
25-Nov-07
30-Nov-07
25-Nov-07
30-Nov-07
18-Nov-07
30-Nov-07
30-Nov-07
30-Nov-07
1-Nov-07

Excel 2003 Data in Excel 2007 File
Change To:
19-Nov-11
26-Nov-11
1-Dec-11
26-Nov-11
1-Dec-11
19-Nov-11
1-Dec-11
1-Dec-11
1-Dec-11
2-Nov-11

Does any one know why?