| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting MM/DD/YYYY into just MM/DD and Sorting
I have several thousand dates that I imported into and excel sheet and need
to sort it by MM/DD only. The years are all different. I tried to format the cells in the column by MM/DD and then sort, but it is still sorting by MM/DD/YYYY. How do format the cells to drop the YYYY and only leave the MM/DD without going into each cell and deleting the YYYY from each cell? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Converting MM/DD/YYYY into just MM/DD and Sorting
Insert a column. Formula: =TEXT(A1,"mmdd")
Sort on that column -- Kind regards, Niek Otten Microsoft MVP - Excel "Jon C." <Jon wrote in message ... I have several thousand dates that I imported into and excel sheet and need to sort it by MM/DD only. The years are all different. I tried to format the cells in the column by MM/DD and then sort, but it is still sorting by MM/DD/YYYY. How do format the cells to drop the YYYY and only leave the MM/DD without going into each cell and deleting the YYYY from each cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a 10 digit serial number to a date of mm/dd/yyyy | Excel Discussion (Misc queries) | |||
| Converting mm/dd/yyyy to yyyy/mm/dd | Excel Worksheet Functions | |||
| converting dd/mm/yy to mm/dd/yyyy | Excel Worksheet Functions | |||
| Converting Day, Date Month Year format to MM/DD/YYYY | Excel Worksheet Functions | |||
| Converting DD/MM/YYYY format into text MMYYYY | Excel Discussion (Misc queries) | |||
Linear Mode
