| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Why do my dates change when I copy them between Excel worksheets?
I often copy cell contents from one worksheet and post them into a new one.
When I copy one set of dates and paste them into a new worksheet, the date falls back one day and to 2001. For example, an original date of May 30, 2005 copies as May 29, 2001. Our agency's IT guru can't figure it out. I could use some help to end this frustrating error. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Problems... | Excel Discussion (Misc queries) | |||
| Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
| how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Threaded Mode
