Are these cells formatted as a Date format or are they formatted as
Text? If they are formatted as Date, Do you really need to delete the
year or can you just change the format so the year doesn't show?

If you set the format to MM/dd it should show the way you want it to
without deleting any data. There is even a predefined formatt for
this: "Format Cells" dialog box"Number" tab"Date" Category. It is
the third one in the "Type" list on my computer ("3/14")

I hope this helps,

Conan Kelly



"kb" wrote in message
...
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