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