how do i enter a date before jan 1, 1900 into excel?

[Guest]

any date entered before jan 1 1900 is being entered as text.. I understand
the dating system so this didn't surprise me.. any way around it? can I enter
a date before Jan 1 1900 and have it stored as a date.. not text?


this would go for jan 1, 1904 on a Mac as well..
thanks

 

[Bob Phillips]

John Walkenbach's free Extended Date Functions addin handles dates from 400
through to 31-Dec-9999

http://j-walk.com/ss/excel/files/general.htm


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)