I am not familar with 2007, but assume the issue is the same as with 2003
the date format is different for macs than for IBMs
try
tools-options-calulation set 1904 date system. (the path may be different
for 2007)

"cuaseli" wrote:

Hi! I have a "2 week old" new computer at the office. I am currently using
windows XP with microsoft excel 2007. Prior to this, i was using IMAC.
After transferring all my old excel files from IMAC to my new computer, I
discovered that when i "move/copy" a sheet from the file created in my IMAC
to a new worksheet, the dates just automatically changes.
Can somebody please help me with this.