Copy and Paste Date - weird behavior
I copied a cell containing dates to a new workbook and the date changes by 1
day and the year changes from 2006 to 2003. For example I have 1/20/2006 and
the new workbook shows 1/19/2003. I looked at the cell formats and I see that
it's a date with an "*" in front of the format. Anyone knows why? How can I
fix it so that it copies and pastes correctly.
Thanks
|