View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
matelot matelot is offline
external usenet poster
 
Posts: 72
Default 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