Dates prior to 1900 in Excel

S

slick

I'm copying information from a Family Tree Program into an Excel Spreadsheet.
However due to the Excel Program limitations on dates, any date prior to 1900
imported will not convert to the proper date. I don't want to go back through
all the dates and re-enter them again with a "'" so they will take. Is there
a way I can set the criteria for my worksheet to accept the imported dates as
they are?

Thanks ahead of time for any help on this topic,
Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates prior to 1900 are text 3
How do I Modify Julian calendar restriction of 1900 2
Recognising dates pre-1900 14
calculating dates prior to a given date 1
Dates in Excel 2007 7
Blank dates showing as 00 january 1900 - help 3
Inserting slashes in dates in Excel 1
Dates prior to 1900 2

Top