Home |
Search |
Today's Posts |
#1
|
|||
|
|||
remove a year from date value in mulitple cells
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function for a 'year to date' sum | Excel Worksheet Functions | |||
Seed date formats to different year in different cells | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
How to get only the year in the date format in Access | New Users to Excel | |||
Date Formatted Cells | Excel Worksheet Functions |