Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Why I could not sort month/year text now ?
Hi,
I could sort the month / year text in ascending or descending order without having to convert it to a date previously : E.g. January 2008 February 2008 March 2008 However after my system recovered from a virus attack, I find that this function is no more working. I find that I could only sort after using Text to Column to convert the tect to a date format such as: Jan-08 Feb-08 Mar-08. Is there anything I could do to restore the original sorting functionality ? Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: Why I could not sort month/year text now ?
Hi
Maybe you had a Custom List set up originally. ToolsOptionsCustom Liststype your list in the white paneOK Then, the sort will take place in the way that you require. -- Regards Roger Govier "Mr. Low" wrote in message ... Hi, I could sort the month / year text in ascending or descending order without having to convert it to a date previously : E.g. January 2008 February 2008 March 2008 However after my system recovered from a virus attack, I find that this function is no more working. I find that I could only sort after using Text to Column to convert the tect to a date format such as: Jan-08 Feb-08 Mar-08. Is there anything I could do to restore the original sorting functionality ? Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to sum by month and year ? | Excel Discussion (Misc queries) | |||
Excel 2002 : How to sum up items by month, date and year ? | Excel Discussion (Misc queries) | |||
Sort by Month and Year | Excel Discussion (Misc queries) | |||
Am I able to sort dates by month rather than year in excel? | Excel Discussion (Misc queries) | |||
sort dates by month and day not year | Excel Worksheet Functions |