I receive a spreadsheet from someone and then copy/paste as values into my
spreadsheet. When I do that the dates change and I've tried formatting the
original sheet, checking input for issues (extra space in front is one
sometimes), but can't seem to get it to copy cleanly. It seems to add a day
and 4 years. Then I take my spreadsheet and put it into a new book and the
dates change just making a copy of the sheet, but this time it deducts a day
and 4 years. Other people in my copy who have done this report have had
similar or same issues with the date column. We just upgraded to 2007
version but was a problem prior to that.