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

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

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

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

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

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