I am trying to do a genealogy spreadsheet. I have dates in several different
formats. If I have a date like 1795 and put it in a date formatted field it
will change to something like Nov. 29, 1904.
1750 changes to 10/15/1904
1800 changes to 12/4/1904
1850 will change to 1/23/1905
The only way to make them stay 1750 1800 and 1850 is to enter them as text
by using '1750, '1800. '1850

Is there a fix or addin or something that will allow me to just paste the
data in and be done with it. I lose lots of time checking all dates after
say 1910 to make sure they are right or need to be changed to 1750 etc.

Thanks
Mary Ellis

Hi Mary,

Look at John Walkenbach's Extended Date Function add-in:

http://www.j-walk.com/ss/excel/files/xdate.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mary Ellis" wrote in message ...
| I am trying to do a genealogy spreadsheet. I have dates in several different
| formats. If I have a date like 1795 and put it in a date formatted field it
| will change to something like Nov. 29, 1904.
| 1750 changes to 10/15/1904
| 1800 changes to 12/4/1904
| 1850 will change to 1/23/1905
| The only way to make them stay 1750 1800 and 1850 is to enter them as text
| by using '1750, '1800. '1850
|
| Is there a fix or addin or something that will allow me to just paste the
| data in and be done with it. I lose lots of time checking all dates after
| say 1910 to make sure they are right or need to be changed to 1750 etc.
|
| Thanks
| Mary Ellis