Copy from worksheet to worksheet
 

When I copy data in one sheet to another sheet , the data is automatically
changed. The cells being transferred where all data that has been entered
with no cell functions being used. For example, I have dates in the format
month/day/year that show different dates when copied to a new worksheet.
These new worksheets can be completely blank yet the data still changes when
pasted onto to a new worksheet.

Copy from worksheet to worksheet
 

If dates are being changed, it may be that one worksheet is in 1904 date
format while the other is in the default 1900 date format. Do they change
by something close to 4 years?
--
David Biddulph

"Bob" wrote in message
...
When I copy data in one sheet to another sheet , the data is automatically
changed. The cells being transferred where all data that has been entered
with no cell functions being used. For example, I have dates in the
format
month/day/year that show different dates when copied to a new worksheet.
These new worksheets can be completely blank yet the data still changes
when
pasted onto to a new worksheet.

Copy from worksheet to worksheet
 

I'm having the same problem, and yes, it's by 4 years... is there a fix?
Colleen

"David Biddulph" wrote:

If dates are being changed, it may be that one worksheet is in 1904 date
format while the other is in the default 1900 date format. Do they change
by something close to 4 years?
--
David Biddulph

"Bob" wrote in message
...
When I copy data in one sheet to another sheet , the data is automatically
changed. The cells being transferred where all data that has been entered
with no cell functions being used. For example, I have dates in the
format
month/day/year that show different dates when copied to a new worksheet.
These new worksheets can be completely blank yet the data still changes
when
pasted onto to a new worksheet.

Copy from worksheet to worksheet
 

Thanks for making me think! I found the solution in the HELP screens :)


"Colleen A" wrote:

I'm having the same problem, and yes, it's by 4 years... is there a fix?
Colleen

"David Biddulph" wrote:

If dates are being changed, it may be that one worksheet is in 1904 date
format while the other is in the default 1900 date format. Do they change
by something close to 4 years?
--
David Biddulph

"Bob" wrote in message
...
When I copy data in one sheet to another sheet , the data is automatically
changed. The cells being transferred where all data that has been entered
with no cell functions being used. For example, I have dates in the
format
month/day/year that show different dates when copied to a new worksheet.
These new worksheets can be completely blank yet the data still changes
when
pasted onto to a new worksheet.