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
|