| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date
Hi, I have two worksheets, let's call them #1 and #2, both have multiple
worksheets which are linked to other worksheets in the same workbook. I want to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2. All numbers get copied fine except for the date. So, for example, when I copy the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all the other dates. I've checked the formatting and all but can't figure why the date would not copy exactly. One thing that may be affecting this is that the two worksheets were constructed on different computers...but dunno why that would make any difference. I've even saved both files as "Macro-Enabled" but to no avail. I'm stumped...would appreciate help. Thanks! rooter |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date
This can happen if the dates are the result of formulas and the cells being
referenced are not the same in both sheets. Try this: 1. copy a cell 2. paste/special/value 3.paste/special formats -- Gary''s Student - gsnu200786 "rooter" wrote: Hi, I have two worksheets, let's call them #1 and #2, both have multiple worksheets which are linked to other worksheets in the same workbook. I want to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2. All numbers get copied fine except for the date. So, for example, when I copy the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all the other dates. I've checked the formatting and all but can't figure why the date would not copy exactly. One thing that may be affecting this is that the two worksheets were constructed on different computers...but dunno why that would make any difference. I've even saved both files as "Macro-Enabled" but to no avail. I'm stumped...would appreciate help. Thanks! rooter |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date
03Thanks! I tried that and it did not work. 12/31/2007 in sheet 1 Book 1
keeps showing up as 12/30/2003 in sheet 2 book 2. I copy as value and then format. Its very strange and I'm not able to get around it. "Gary''s Student" wrote: This can happen if the dates are the result of formulas and the cells being referenced are not the same in both sheets. Try this: 1. copy a cell 2. paste/special/value 3.paste/special formats -- Gary''s Student - gsnu200786 "rooter" wrote: Hi, I have two worksheets, let's call them #1 and #2, both have multiple worksheets which are linked to other worksheets in the same workbook. I want to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2. All numbers get copied fine except for the date. So, for example, when I copy the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all the other dates. I've checked the formatting and all but can't figure why the date would not copy exactly. One thing that may be affecting this is that the two worksheets were constructed on different computers...but dunno why that would make any difference. I've even saved both files as "Macro-Enabled" but to no avail. I'm stumped...would appreciate help. Thanks! rooter |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date
It sounds as if one is in 1904 date format and the other in 1900 date
format. -- David Biddulph "rooter" wrote in message ... 03Thanks! I tried that and it did not work. 12/31/2007 in sheet 1 Book 1 keeps showing up as 12/30/2003 in sheet 2 book 2. I copy as value and then format. Its very strange and I'm not able to get around it. "Gary''s Student" wrote: This can happen if the dates are the result of formulas and the cells being referenced are not the same in both sheets. Try this: 1. copy a cell 2. paste/special/value 3.paste/special formats -- Gary''s Student - gsnu200786 "rooter" wrote: Hi, I have two worksheets, let's call them #1 and #2, both have multiple worksheets which are linked to other worksheets in the same workbook. I want to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2. All numbers get copied fine except for the date. So, for example, when I copy the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all the other dates. I've checked the formatting and all but can't figure why the date would not copy exactly. One thing that may be affecting this is that the two worksheets were constructed on different computers...but dunno why that would make any difference. I've even saved both files as "Macro-Enabled" but to no avail. I'm stumped...would appreciate help. Thanks! rooter |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date
If you go to ToolsOptionsCalculation you will find at the bottom of dialog, a
checkbox for 1904 date system. BTW..........it is 4 years and 1 day difference. Add or subtract 1462 days to alter. Gord Dibben MS Excel MVP On Fri, 16 May 2008 08:41:01 -0700, rooter wrote: Hi, I have two worksheets, let's call them #1 and #2, both have multiple worksheets which are linked to other worksheets in the same workbook. I want to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2. All numbers get copied fine except for the date. So, for example, when I copy the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all the other dates. I've checked the formatting and all but can't figure why the date would not copy exactly. One thing that may be affecting this is that the two worksheets were constructed on different computers...but dunno why that would make any difference. I've even saved both files as "Macro-Enabled" but to no avail. I'm stumped...would appreciate help. Thanks! rooter |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date
Thank you, David ad Gord...yes, one file was done on a Mac and the other on
PC. Its solved. Appreciate it. "Gord Dibben" wrote: If you go to ToolsOptionsCalculation you will find at the bottom of dialog, a checkbox for 1904 date system. BTW..........it is 4 years and 1 day difference. Add or subtract 1462 days to alter. Gord Dibben MS Excel MVP On Fri, 16 May 2008 08:41:01 -0700, rooter wrote: Hi, I have two worksheets, let's call them #1 and #2, both have multiple worksheets which are linked to other worksheets in the same workbook. I want to take data from Sheet #1-Book #1 and copy it as values on Sheet #1-Book#2. All numbers get copied fine except for the date. So, for example, when I copy the date 12/31/07 it shows up in Book#2 as 12/30/2003 and the same for all the other dates. I've checked the formatting and all but can't figure why the date would not copy exactly. One thing that may be affecting this is that the two worksheets were constructed on different computers...but dunno why that would make any difference. I've even saved both files as "Macro-Enabled" but to no avail. I'm stumped...would appreciate help. Thanks! rooter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
