Pre-1900 dates in Excel?
July 19, 2006 11:25 AM Subscribe
Is there any way to make Microsoft Excel recognize dates before 1900?
posted by marxchivist to Computers & Internet (10 answers total) 1 user marked this as a favorite
I'm working on a project where I'm creating a long list of names and dates, with the dates spanning 1885 to the 1930's. I'd like to be able to sort by date, but Excel doesn't recognize years before 1900. If I format the cells to show the date as mm/dd/yyyy I can type in the nineteenth-century years and they show that way, but they won't sort. I looked at this thread
but didn't see an answer to my question.
While trying to Google this, I found the Wikipedia entry on Y2K says "Unfortunately, the Windows versions of the program by default start at 1900 and the Mac versions by default starts at 1904 (although this can usually be changed)
." [italics mine]
Office 2000 with XP.