Just format it as such:

Select your range, Format-Cells-'Number' tab-Date, and choose the way you
would like your values to be displayed.


--
Regards,
Dave


"kb" wrote:

I have about 1,000 cells with a xx/dd/yyyy format. I am trying to delete
just the year in each cell so that it shows only the month and day. Is there
a formula I can use to globally delete the year from each cell? Thanks, Karen