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)

"barry" wrote in message
...
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