This is completely bizarre, and not sure why. I am trying to copy data from one spreadsheet to another containing dates in dates format.
However, once copied to the new sheet, the year is exactly four years earlier than the original. eg. 29-Nov-09 (original sheet) -> 29-Nov-05 (new sheet). I have tried many things, copy/paste value, copy/paste all, open new spreadsheets many time, and saving files in various xls formats. Still no luck.
Then I tried entering the number 1, into the original spreadsheet and format as date. Surprisingly, the date is 2-jan-1904, but in a normal spreadsheet, number 1 would be 1-jan-1900. Very weird.
Anyone know what the problem is? And how can I copy the dates correctly over to a new sheets? Thanks.
However, once copied to the new sheet, the year is exactly four years earlier than the original. eg. 29-Nov-09 (original sheet) -> 29-Nov-05 (new sheet). I have tried many things, copy/paste value, copy/paste all, open new spreadsheets many time, and saving files in various xls formats. Still no luck.
Then I tried entering the number 1, into the original spreadsheet and format as date. Surprisingly, the date is 2-jan-1904, but in a normal spreadsheet, number 1 would be 1-jan-1900. Very weird.
Anyone know what the problem is? And how can I copy the dates correctly over to a new sheets? Thanks.