calculate with dates before 1-1-1900
 

how can i calculate with dates before 1-1-1900? i also can't change the
property of the cell when using dates before 1-1-1900.

Here's something that may help.

http://www.j-walk.com/ss/excel/usertips/tip028.htm



"jan wan" wrote in message
...
how can i calculate with dates before 1-1-1900? i also can't change the
property of the cell when using dates before 1-1-1900.

Excel's "true" dates start with Jan 1, 1900. It doesn't natively support
earlier dates. To use them requires that they be entered as text and
manipulated with VBA routines.

Depending on your need for these dates, the database program Access can handle
these dates and may be a better choice for you it you have it.


On Fri, 29 Oct 2004 23:21:04 +0200, "jan wan" wrote:

how can i calculate with dates before 1-1-1900? i also can't change the
property of the cell when using dates before 1-1-1900.

Works perfectly. thank you.

"Dave R." schreef in bericht
...
Here's something that may help.

http://www.j-walk.com/ss/excel/usertips/tip028.htm



"jan wan" wrote in message
...
how can i calculate with dates before 1-1-1900? i also can't change the
property of the cell when using dates before 1-1-1900.