Excel's date system starts with 1-1-1900.

If you need older dates (not just as text), you could download John
Walkenbach's extended date functions. You'll need the special functions that
go with it to calculate with those dates.

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

--
Kind regards,

Niek Otten

"Alexandre Duarte" wrote in
message ...
Hi everyone.
I have a worksheet with two columns. The first with date and the other
with
text formated cells.
When I enter in the first one data with the year < 1900 the format never
assumes the right date format
Can anyone provide me with some explanation about this?
Regs
Alexandre Duarte