=concatenate(month(3/15/1974),"/",day(3/15/1974))

Copy, paste special, values, and there you go.

Dave
--
Brevity is the soul of wit.


"Vicky" wrote:

For example, I want to show 3/15/1974 as 3/15. I do not want someone to be
able to switch back the formatting so that they can determine the year.
Thanks!