G Guest Apr 19, 2007 #1 I am using data in Excel 2007 from Access 2007 but Excel does not recognize dates in the 1800's. Any resolution to this error? Marian
I am using data in Excel 2007 from Access 2007 but Excel does not recognize dates in the 1800's. Any resolution to this error? Marian
N Nick Hodge Apr 22, 2007 #2 Marian This is not 2007 specific, it has been the same for all versions of XL. You can only enter them as text and then no calculations are possible on this -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk
Marian This is not 2007 specific, it has been the same for all versions of XL. You can only enter them as text and then no calculations are possible on this -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk