Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Dates change when sheet copied to a new workbook
Everytime I copy or move a spreadsheet with dates to a new workbook, the
dates change. I have tried removing formulas from the dates, but nothing works. It is very time consuming to keep fixing this. What on earth am I doing wrong |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Dates change when sheet copied to a new workbook
Are the dates different by 4 years and 1 day?
If yes... One workbook was using a base year of 1900 and the other was using 1904. (tools|options|calculation tab|1904 date system in xl2003 menus) One way to add (or subtract) those four years back is to find an empty cell, put 1462 into that cell. Copy that cell. Select your range that contains the dates. Edit|PasteSpecial|click Add (or subtract) (in theoperation box) and check values. You may want to do it against a copy...just in case. Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as the base date. Robyns521 wrote: Everytime I copy or move a spreadsheet with dates to a new workbook, the dates change. I have tried removing formulas from the dates, but nothing works. It is very time consuming to keep fixing this. What on earth am I doing wrong -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Dates change when sheet copied to a new workbook
"Dave Peterson" wrote: Are the dates different by 4 years and 1 day? If yes... One workbook was using a base year of 1900 and the other was using 1904. (tools|options|calculation tab|1904 date system in xl2003 menus) One way to add (or subtract) those four years back is to find an empty cell, put 1462 into that cell. Copy that cell. Select your range that contains the dates. Edit|PasteSpecial|click Add (or subtract) (in theoperation box) and check values. You may want to do it against a copy...just in case. Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as the base date. Robyns521 wrote: Everytime I copy or move a spreadsheet with dates to a new workbook, the dates change. I have tried removing formulas from the dates, but nothing works. It is very time consuming to keep fixing this. What on earth am I doing wrong -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Dates change when sheet copied to a new workbook
"Dave Peterson" wrote: Are the dates different by 4 years and 1 day? If yes... One workbook was using a base year of 1900 and the other was using 1904. (tools|options|calculation tab|1904 date system in xl2003 menus) One way to add (or subtract) those four years back is to find an empty cell, put 1462 into that cell. Copy that cell. Select your range that contains the dates. Edit|PasteSpecial|click Add (or subtract) (in theoperation box) and check values. You may want to do it against a copy...just in case. Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as the base date. Robyns521 wrote: Everytime I copy or move a spreadsheet with dates to a new workbook, the dates change. I have tried removing formulas from the dates, but nothing works. It is very time consuming to keep fixing this. What on earth am I doing wrong -- Dave Peterson Dave, Thanks for the tip! I was driving myself nuts trying to solve the problem. Your solution works PERFECTLY! Stan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
The Dates change when sheet copied to a new workbook
Glad it worked for you.
Stan F wrote: "Dave Peterson" wrote: Are the dates different by 4 years and 1 day? If yes... One workbook was using a base year of 1900 and the other was using 1904. (tools|options|calculation tab|1904 date system in xl2003 menus) One way to add (or subtract) those four years back is to find an empty cell, put 1462 into that cell. Copy that cell. Select your range that contains the dates. Edit|PasteSpecial|click Add (or subtract) (in theoperation box) and check values. You may want to do it against a copy...just in case. Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as the base date. Robyns521 wrote: Everytime I copy or move a spreadsheet with dates to a new workbook, the dates change. I have tried removing formulas from the dates, but nothing works. It is very time consuming to keep fixing this. What on earth am I doing wrong -- Dave Peterson Dave, Thanks for the tip! I was driving myself nuts trying to solve the problem. Your solution works PERFECTLY! Stan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates change when copied to new workbook or worksheet | Excel Discussion (Misc queries) | |||
How to add formula calling up current workbook when sheet copied | Excel Discussion (Misc queries) | |||
dates change when copied form 1 spreadsheet to another | Excel Discussion (Misc queries) | |||
Copied dates automatically change to previous day | About this forum | |||
When Copying a sheet, the whole workbook gets copied | Excel Discussion (Misc queries) |