Excel 2007 doesn't recognize dates prior to 1900. Dates entered prior to 1900
are not formatted as dates, but seem to become text. I can't do calculations
between such dates...what gives?

Anyone know how to over come this horrible limitation?