| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem copying dates
Hi
Go to ToolsOptionsCalculation and untick the 1904 Date option. -- Regards Roger Govier "iontrap" wrote in message ... I am copying dates from one workbook to another. Everytime I copy a date into the new workbook, the date is incorrect: 10/12/2005 becomes 10/11/2001 and 1/18/2006 becomes 1/17/2002. This is the first time I have run into this problem, is there a solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Dates | Excel Discussion (Misc queries) | |||
| Copying worksheet problem | Excel Discussion (Misc queries) | |||
| Problem with pasting dates - year mysteriously changes | Excel Worksheet Functions | |||
| Problem with copying formula | Excel Discussion (Misc queries) | |||
| Problem with copying Hyperlinks | Excel Discussion (Misc queries) | |||
Threaded Mode
