Excel Question: Why is it when I copy my work from one excel document with dates in it. Along with other things i.e currency using the copy command it pastes the wrong dates in the field. I.E 3/2/07 becomes 3/1/02 Whats more weird is both spreedsheets retain the same formula yet the date is total different even with the same formula. I got no clue why. But when I copy then paste in notepad then paste in excel theres no problem. Sorry just a weird question for you excel experts. I don't understand the reason for this.