If your date is actually TEXT, then.....
=RIGHT(A1,2)
or
=20&RIGHT(A1,2)

Vaya con Dios,
Chuck, CABGx3


"grendel" wrote in message
...
i have a standard date of 9/1/06 and am trying to isolate the year in
another
column. i have used
text(right(a2,2),"yy")), but am getting incorrect years. i have also
tried
datevalue(right(a2,2)) and keep getting value errors.