L
Lasse
Hi.
I have a date problem. I have got a workbook with a date column from a
friend.
When I copy a cell from the date colomn and past it in another workbook I
get a different date.
When I format it in text format, there are the same numbers.
For example:
I have a cell with format Date (15-3 05) and the cell value 27-5 05. (The
value for this cell in text format is 37037). I copy this cell and past it
in a New Workbook, and the date is 26-5 01. I look at the format and it´s
the same. And the value in text format is also the same, 37037.
But when I past it in the same workbook I copy it from, the date is correct.
How can this happend?
Does anybody know a reason for this happening?
//Lasse
I have a date problem. I have got a workbook with a date column from a
friend.
When I copy a cell from the date colomn and past it in another workbook I
get a different date.
When I format it in text format, there are the same numbers.
For example:
I have a cell with format Date (15-3 05) and the cell value 27-5 05. (The
value for this cell in text format is 37037). I copy this cell and past it
in a New Workbook, and the date is 26-5 01. I look at the format and it´s
the same. And the value in text format is also the same, 37037.
But when I past it in the same workbook I copy it from, the date is correct.
How can this happend?
Does anybody know a reason for this happening?
//Lasse