pasted dates changing

[Guest]

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.

 

[Ron Rosenfeld]

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.

Tools/Options/Calculations Workbook Options and DeSelect "1904 Date System"

If your date formatting included the year, you would see that the year was also
changing.


--ron