View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Issue with copy/paste dates from filtered data

One of the sheets seems to be operating with the 1904 date convention -
to rectify this, go to Tools | Options | Calculation tab and uncheck
the 1904 dates option near the bottom. Alternatively, if this is the
one with the correct dates, do the reverse for the other sheet.

Pete