Hi Karen

FormatCellsNumberCustom and in the white pane type mm/dd or any
combination to get the format you like.
mm will give month number
mmm will give Jan, Feb etc.
mmmm will give January, February etc.

Regards

Roger Govier



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