Dates prior to 1900 in Excel

G

Guest

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 2
Dates prior to 1900 are text 3
Recognising dates pre-1900 14
Formatting dates prior to 1900 7
Dates in Excel 2007 5
Dates prior to 01-Jan-1900 2
Dates earlier than 1900 2
Excel dates prior to 01/01/1900 2

Top