| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
year changes when copied from one workbook to another
I receive a file from one department and copy the information into another
file. When I do this the date changes. It adds one day and four years to the date. The options has the 1904 date system selected. When I turn this off the dates come in correctly but the rest of my dates in the worksheet change. What can I do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| year changes when copied from one workbook to another | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
