pasted dates changing

R

rubber

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.
 
R

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.
Click to expand...

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
 
Top