Hi
use if you want text values
=TEXT(A1,"MM/DD")
and
=TEXT(A1,"YY")

if you still want the date values but just displayed this way use
=A1
in both cells and apply a custom format ('Format -Cells') such as
MM/DD
and
YY


--
Regards
Frank Kabel
Frankfurt, Germany


Robert Judge wrote:
I have an EXCEL 97 worksheet that includes a column with birthdays in
the format 11/13/51, for instance, for November 13, 1951. I would
like to split that column into two columns. The first column would
contain the month and day (that is, 11/13) and the second column
would contain the year (that is, 51). How can I do this?