Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
Filtering with dates | Excel Discussion (Misc queries) |