=MONTH(A1)&"/"&DAY(A1)
Then you could Copy & Paste Special - Values
but this will be text so no calculations are possible
or, Maybe Hide column A
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mollas" wrote in message
...
Hello,

How do I split the year from a date. Example I will need to extract 2/23
and leave out 1978. The purpose is so that viewers can not reformat the
text
to find out the year.