View Single Post
  #1   Report Post  
rubber
 
Posts: n/a
Default pasted dates changing

I am copying a worksheet in Excel 2000 with dates formated as 14-Mar. When I
copy to a new worksheet, the dates change. Even if I format the new cells to
14-Mar, the new date is one day prior. I have tried paste special (values),
but this doesn't work either.