Date changes when copied

  • Thread starter Thread starter Mathieu
  • Start date Start date
M

Mathieu

I've got an excel file where all the dates were changed.
The cell format is "Date (14-mar-98)".
Funny thing, if I try to copy a cell on another worksheet in another
workbook with the same cell format, the data will change.
Les say you have 01-Dec-03, it'll change to 30-Nov-99 in the new workbook!

Ok, if you follow me, here is another one. You know that if you change a
"date" cell format into "general"... the data inside that cell will give you
a number (try it if you've never done it). So 01-Dec-03 on the corrupt file
gives 36494 when the cell format is changed to "general". If its changed
back to the "date" format, I'll get back 01-Ded-03. If I do the same
excercice on the new workbook with the copied date (30-Nov-99)...it'll give
me 36494, change it back to "date" format, and it gives 30-Nov-99.

Do you have an explanation before I throw my computer out the window!

thanks

Mathieu
 
The workbook was created using the 1904 date system
(tools>options>calculations)
It is used since it will return negative time while the default returns
####### for negative time
You can fix it easily, in the workbook you can put 1462 in an empty cell,
copy it, in the new workbook select all dates
that changed to earlier dates and do edit>paste special and select add. That
will give you correct dates
Not a corrupt file
 
You are right... that is the reason

Peo Sjoblom said:
The workbook was created using the 1904 date system
(tools>options>calculations)
It is used since it will return negative time while the default returns
####### for negative time
You can fix it easily, in the workbook you can put 1462 in an empty cell,
copy it, in the new workbook select all dates
that changed to earlier dates and do edit>paste special and select add. That
will give you correct dates
Not a corrupt file

--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top