calculate with dates before 1-1-1900

J

jan wan

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.
 
M

Myrna Larson

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.
 
Top