Thread: Date Probleme
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MESTRELLA29 MESTRELLA29 is offline
external usenet poster
 
Posts: 26
Default 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?