remove a year from date value in mulitple cells

K

kb

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
 
D

David Billigmeier

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.
 
R

Roger Govier

Hi Karen

Format>Cells>Number>Custom 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
 
C

Conan Kelly

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
 
Top