excel - Converting mmyy into a useable date -

my question similar problem, excel: how convert mmyy last day of month in netezza or one: create date credit card expire in mmyy format.

essentially have column filled dates have been written mmyy i.e.

0215
0215
0215
0315
0315

the column has been saved data type: "special".

how convert data useable format? don't mind if put dd/mm/yyyy , use first or last day of month that's fine. there excel function use or have in vba , if so, how?

with 'dates' starting in a2, use formula in unused column right,

=date(20&right(a2, 2), left(text(a2, "0000"), 2), 1) 

fill down necessary. have format date or receive raw date value 42064.

if need end-of-month, add 1 month , change day 0 like,

=date(20&right(a2, 2), left(text(a2, "0000"), 2)+1, 0)