Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting data by date
I need help sorting some dates into month order. The information has been
exported from another system into an Excel spreadsheet. At present the data is in dd/mm/yy format. I want to sort the information by month. The data sort function will only sort it by day at present. How can I change the format so that I can sort by month? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching a sorting the exact value in the data list | Excel Discussion (Misc queries) | |||
Sorting data by date | Excel Worksheet Functions | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions |