View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nwg
 
Posts: n/a
Default years change to current year

When copying data with a column of dates to another worksheet the year will
change to the current year instead of the year the (row) data represents.
The 11/04 or Nov-04 (or any previous year) becomes 11/05 or Nov-05. Also
this nor the numeric dates format seems to work between Quatro and Excel. I
need to keep the month and year that was originally input in order to sort
data by month and year and to combine monthly data from previous years work.