Copy and paste question in Excel

[Ira_S.]

Hi, all. I've been having a very strange thing happen when I attempt to copy and paste a date from one sheet to another: even though the cell's formats match each other, the copied date (say it's 2/27/08) always shows up upon pasting as one day and four years later (in this instance, 2/28/12). Any idea why this is happening?

BTW, I copied and pasted those dates in from Excel.

Thanks for your help.

 

[CyberTaz]

Exel supports 2 date systems - 1900 & 1904. The system is imposed on a
per-file basis, so it sounds like you're copying from a file that uses one
system & pasting to a file that uses the other. Have a look here:

http://support.microsoft.com/kb/180162

If you have further questions post to the microsoft.public.mac.office.excel
newsgroup for help.