Changing all dates to 1900 instead of 2000

[Excel Ron]

I have a set of dates that after doing text to colums and seting the up MDY some of them are popping out dates of birth as ex: 2026, 2045, 2088. Obviously these are 1926, 1945, & 1988. Is there an easy way to change from the 2000 format to the 1900 format? Thanks in advance!!

 

[dave3009]

Maybe like this

Excel Workbook
	A	B
1	12/12/2029	12/12/1929
2	10/11/2019	10/11/1919
3	01/02/2056	01/02/1956
4	01/01/1976	01/01/1976
5	01/02/2010	01/02/2010
Sheet6

Excel 2007

Cell Formulas
Range	Formula
B1	=IF(YEAR(A1)>YEAR(TODAY()), DATE(YEAR(A1)-100, MONTH(A1), DAY(A1)), A1)

 

[Excel Ron]

Worked Perfectly!! Thanks!!