| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When copying dates, they change by 4 yrs & 1 day, why?
When copying & pasting dates in a few of my worksheets, they change to one
day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone tell me what I am doing wrong? Thank you, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
When copying dates, they change by 4 yrs & 1 day, why?
Copy Paste Special Values OK
"CAMiller" wrote: When copying & pasting dates in a few of my worksheets, they change to one day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone tell me what I am doing wrong? Thank you, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
When copying dates, they change by 4 yrs & 1 day, why?
Some of your Workbooks are set up to use the 1904 date system, others are
not, so they default to the 1901 date system. You'll find the setting under Tools-Options. Not sure which tab for Excel versions prior to 2007 (I've been upgraded to Excel 2007 - there it is under Excel Options on the Advanced tab) "CAMiller" wrote: When copying & pasting dates in a few of my worksheets, they change to one day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone tell me what I am doing wrong? Thank you, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
When copying dates, they change by 4 yrs & 1 day, why?
It's under toolsoptionscalculation in pre 2007 versions
-- Regards, Peo Sjoblom "Duke Carey" wrote in message ... Some of your Workbooks are set up to use the 1904 date system, others are not, so they default to the 1901 date system. You'll find the setting under Tools-Options. Not sure which tab for Excel versions prior to 2007 (I've been upgraded to Excel 2007 - there it is under Excel Options on the Advanced tab) "CAMiller" wrote: When copying & pasting dates in a few of my worksheets, they change to one day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone tell me what I am doing wrong? Thank you, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
When copying dates, they change by 4 yrs & 1 day, why?
It sounds like the source is set to use the 1904 date system.
Goto ToolsOptionsCalculation tab1904 date system Uncheck that setting. Be careful though, this will change all the dates already entered. This will add 4 years to your existing dates. -- Biff Microsoft Excel MVP "CAMiller" wrote in message ... When copying & pasting dates in a few of my worksheets, they change to one day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone tell me what I am doing wrong? Thank you, |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
When copying dates, they change by 4 yrs & 1 day, why?
Hallelujah! Thanks for tip. Saved me hours!!!
"T. Valko" wrote: It sounds like the source is set to use the 1904 date system. Goto ToolsOptionsCalculation tab1904 date system Uncheck that setting. Be careful though, this will change all the dates already entered. This will add 4 years to your existing dates. -- Biff Microsoft Excel MVP "CAMiller" wrote in message ... When copying & pasting dates in a few of my worksheets, they change to one day and four years backwards, ie: 07/15/1979 changes to 07/14/1975. Can anyone tell me what I am doing wrong? Thank you, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem copying dates | Excel Discussion (Misc queries) | |||
| Copying Dates | Excel Discussion (Misc queries) | |||
| Copying groups of dates | Excel Discussion (Misc queries) | |||
| Problems copying street addresses and dates | Excel Discussion (Misc queries) | |||
| When copying dates to another sheet the dates are different | Excel Worksheet Functions | |||
Linear Mode
