Excel does not recognize pre-1900 dates as other than text. You might check
out this add-in from John Walkenbach which will help:

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

--
Jim
"Gazz" wrote in message
...
| As title asks. Family Tree information finds some earlier dates fail to be
| recognised and formatted as such.