Excel cut/paste prob: Adds one day and changes year to 2009
 

When I cut and paste a date into another worksheet, one day is added and the
year is changed. For example, 2/5/05 will change to 2/6/09. I am using
Office for Mac. How can I avoid this problem. It is compromising my reports
and giving false information.

The workbook you're copying from uses the WinXL default 1900 date system
while your destination workbook is using the MacXL default 1904 date
system.

You can change the destination workbook system (Preferences/Calculation,
uncheck the 1904 date system checkbox). Alternatively, you can enter
1462 in an empty cell. Copy the cell, select your dates, then choose
Edit/Paste Special, selecting the Values and Subtract radio buttons.


In article ,
"Maisha1908" wrote:

When I cut and paste a date into another worksheet, one day is added and the
year is changed. For example, 2/5/05 will change to 2/6/09. I am using
Office for Mac. How can I avoid this problem. It is compromising my reports
and giving false information.

Thanks so much. This works. It appears that I have to change the default
setting for each workbook. Is it possible to have the box unchecked as the
default?
thanks again.

"JE McGimpsey" wrote:

The workbook you're copying from uses the WinXL default 1900 date system
while your destination workbook is using the MacXL default 1904 date
system.

You can change the destination workbook system (Preferences/Calculation,
uncheck the 1904 date system checkbox). Alternatively, you can enter
1462 in an empty cell. Copy the cell, select your dates, then choose
Edit/Paste Special, selecting the Values and Subtract radio buttons.


In article ,
"Maisha1908" wrote:

When I cut and paste a date into another worksheet, one day is added and the
year is changed. For example, 2/5/05 will change to 2/6/09. I am using
Office for Mac. How can I avoid this problem. It is compromising my reports
and giving false information.

The setting depends on the first workbook you open in a session. Open a
1900-system workbook first, and you should be fine.

In article ,
"Maisha1908" wrote:

Thanks so much. This works. It appears that I have to change the default
setting for each workbook. Is it possible to have the box unchecked as the
default?