Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy graph from a Worksheet based on a field in another Worksheet | Excel Worksheet Functions | |||
How do I copy a check box result from Worksheet A to Worksheet B? | Excel Worksheet Functions | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions |