How do I keep date from incrementing on paste to new workbook?

[trixiesirisheyes]

I'm on a MacPro (Intel) using Office:Mac 2004: Student and Teacher Edition.

I'm trying to copy a *large* selection from one workbook that has dates in
one column to another workbook. Unfortunately on paste, it's incrementing it
four years. Ack! No!

It's not a formula, it's just a number formatted as a date.

I have tried paste, paste special->all, paste special->values, paste
special->values and number formats. I have gone into preferences
("properties" to you PC folks) and dug around in there to see if there's
anything I need to turn off or on.

I've hit a wall. Can anyone help me, please? I have to have this report
ready for my board of directors tomorrow night and I can't get this to work.

 

[FSt1]

hi
i suspect that you are pasting into a pc that using a different date system.
there are two. 1900 date system and 1904 date system. switching systems
throws the dates off by four years and one day.
see this site for more info and a possible fix.....
http://support.microsoft.com/kb/180162

regards
FSt1