Using Dates in Excel 2007

[Mary Ellis]

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

 

[Niek Otten]

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

| 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