One way ..

Assuming the dates are in col A, A2 down,

Put:
In B2: =TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2)),"mm/dd")
In C2: =TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2)),"yy")

Select B2:C2, copy down

Col B will return the month/day,
col C will return the year
--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Robert Judge" wrote in message
...
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?