Is this a version problem: I have a large spreadsheet with a date field - need to copy parts to another worksheet or workbook. When I copy a date it is change in the destination cell. Most common change is to keep same month, day one less, and year four years less. So 01/18/06 becomes 01/17/02. Doesn't matter what date format. Just happens over and over and never copies correctly.
If you mouseover the cell after pasting, there should be a little white plus sign w/ a drop down arrow. If you click that, there should be a list about how to take the paste...keep formatting, paste data only, etc. I would experiment w/ that, sometimes you need to change it from default. <edit> it could also very likely be that your cmos clock and/or system clock is...well...wrong.
OK thanks - as I looked at it again - seems like the difference between the 1900 and 1904 date rules - just need to figure out how to change the one workbook to the same setting as all the rest in my system
shouldn't have started this, I guess. I found a check box: in excel tools, options, calculations, 1904 date - seems MACs sometimes use the 1904 convention. Made me a bit nuts. That's all
