Date Probleme
 

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?

Date Probleme
 

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?

Date Probleme
 

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?

Date Probleme
 

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?

Date Probleme
 

I don't have XL2007, but if it is the same as earlier versions:

Tools Options Calculation Uncheck 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
...
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?

Date Probleme
 

Glad that you got it fixed. As a matter or interest is it the same as
earlier versions?

--
Regards,

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
...
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?