Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 : How to sum by month and year ? Mr. Low Excel Discussion (Misc queries) 3 May 15th 07 05:12 PM
Excel 2002 : How to sum up items by month, date and year ? Mr. Low Excel Discussion (Misc queries) 4 November 21st 06 11:51 AM
Sort by Month and Year Yoshi Excel Discussion (Misc queries) 1 February 2nd 06 11:03 PM
Am I able to sort dates by month rather than year in excel? Ruth k. Excel Discussion (Misc queries) 1 November 3rd 05 03:18 PM
sort dates by month and day not year dianne Excel Worksheet Functions 2 March 8th 05 08:16 PM


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"