|Here's another way you might find interesting:|
Cell A1 contains the date your going to break apart:
IE: 04-Apr-09 (The date format does not matter)
First Custom Format Cells B1, B2, B3 with the format 00 (Zero Zero)
Then to break apart the date into it's component parts:
In Cell B1 =MONTH(A1)
In Cell B2 =DAY(A1)
In Cell B3 =TEXT(A1,"yy")
To put all back together in the format MM-DD-YY
In Cell B5 =TEXT(B1&"-"&B2&"-"&B3,"mm-dd-yy")
There is a =YEAR function, but it will return the complete year 2009.
I must say though, I do prefer DerbyDad03's solution for putting the date back together.