Date Probleme

[MESTRELLA29]

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?

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[MESTRELLA29]

OK, How do I change This?

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[MESTRELLA29]

Thanks, This Solved My Issue.

OK, How do I change This?

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk