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