Yes, I meant 6/30/04 becomes 7/1/08. I will try the fix suggested below. I
am working on a PC. Perhaps if someone who is using a MAC sent me the
spreadsheet this would occur? What if it happens on my own PC with my own
spreadsheets, why would it suddenly occur? Is there any way to fix this
inside of EXCEL so that I don't have to worry about this on each spreadsheet?
If I wasn't paying attention, I would not have noticed the errors.
Thanks for your help, nbalch

"nbalch" wrote:

All of a sudden I can't cut and paste a column of dates without Excel
changing the number by one day and several years. ie, 6/30/04 becomes
7/1/05. This happens when cut and pasting into another spreadsheet. I tried
paste special but nothing happens.

Thanks, Noreen