I have data that was imported from another system (don't know what system). The date field shows as 01-01-2005. I need to split the field so that the month is one cell and the year in another (don't need day). I tried the usual right(a1,2) type command, but I get 53 returned. I tried to first convert the date to text, but then I get the full five digit date.

I'm sure that there is an easy solution to this, but I don't know what it is and couldn't locate it in the board archives.

Thank you!!

Carrie