On Fri, 4 Mar 2005 11:29:39 -0800, "Julie"
wrote:

In Excel 2000, I am having trouble with dates retaining when copying a
worksheet from one workbook to another.

For example, in one cell, we have a date of April 8, 2005 and when I copy
the worksheet to another workbook, is changes to April 9, 2009. (it adds 4
years and 1 day)

I have tried several formatting changes - with no luck. HELP PLEASE IT IS
MAKING ME CRAZY!!

The problem is that Excel has two date systems. One is based on the PC
date system (starting 1/1/1900), the other on the Macintosh date
system (starting in 1904).

One of your workbooks is set to use one system, the other, the other
system. Thus the same value = a different date.

You can set the system in use through the Tools - Options -
Calculation tab. It's workbook specific, so just set both workbooks to
the same system.




---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *