I need to convert text inputted in the YYMM format (i.e. 1408= August, 2014) to Date format of MMM-YY (AUG-14)... I cannot for the life of me figure out how to do this. It gives me random dates... I also want to set it up so whoever enters it as 1408 in the future, will have it automatically converted to AUG-14.