| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates prior to 1900 in Excel
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates prior to 1900 in Excel
Take a look he
http://www.j-walk.com/ss/excel/files/xdate.htm "slick" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Excel should handle dates before 1900! | Excel Discussion (Misc queries) | |||
| add/subtract dates problem in Excel..... | Excel Discussion (Misc queries) | |||
| Enter 2 dates in same excel cell | Excel Discussion (Misc queries) | |||
| Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
| graph dates revert to 1900 | Charts and Charting in Excel | |||
Linear Mode
