The formula you need is: =DATE(MID(A1,1,2)+2000,MID(A1,3,2),1)
Then, depending how you want the output to show up, right click on the cell, go to "Number", "Custom" and under "Type":
- type "mm-yyyy" to display as "04-2002"
- type "mmmm yyyy" to display as "April 2002"