Bruce,
Thank you. That worked perfectly.
--
Mytpoet67


"bpeltzer" wrote:

If your first entry is in A2, then
=DATE("20"&RIGHT(A2,2),LEFT(A2,FIND("-",A2)-1),1) will turn that into a date.
Autofill through the entire column.
HTH. --Bruce

"Mytpoet67" wrote:

A co-worker created a spreadsheet with dates keyed in a column as text (e.g.,
'12-03 represents December 2003). I need to convert a very long column of
these "dates" to actual dates in the format MM-YY. Everything I try converts
it to the proper month, but year 05 (2005).

Your help is appreciated.
--
Mytpoet67