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.

On Tue, 11 Jan 2005 23:01:02 -0800, rubber
wrote:

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