I have established a custom list using the three first letters of the 12
months, but need a sorting order to correspond to the Federal fiscal year,
i.e., starting with "Oct" and ending with "Sep." This list in this order has
been saved under the custom list component of Excel. When I want to sort a
number of events by this order, the process changes the order from what it
was before, but not in the order established in the custom list, nor
alphabetical.
I'm working in Windows XP, Excel 2000.

Hi,

Click the Options button on the Dort dialog box (DataSort) Your custom list
should appear in the First Key Sort Order drop down box. Choose it and click
OK.

HTH,
Matt

"gitttep" wrote:

I have established a custom list using the three first letters of the 12
months, but need a sorting order to correspond to the Federal fiscal year,
i.e., starting with "Oct" and ending with "Sep." This list in this order has
been saved under the custom list component of Excel. When I want to sort a
number of events by this order, the process changes the order from what it
was before, but not in the order established in the custom list, nor
alphabetical.
I'm working in Windows XP, Excel 2000.

thanks for taking the time to answer my bulletin. I meant to imply that ,
once I set up the custom list, I also clicked on it in the Options box when
I wanted to perform the sort. No luck! Any other suggestions? Thanks.

"Matt Lunn" wrote:

Hi,

Click the Options button on the Dort dialog box (DataSort) Your custom list
should appear in the First Key Sort Order drop down box. Choose it and click
OK.

HTH,
Matt

"gitttep" wrote:

I have established a custom list using the three first letters of the 12
months, but need a sorting order to correspond to the Federal fiscal year,
i.e., starting with "Oct" and ending with "Sep." This list in this order has
been saved under the custom list component of Excel. When I want to sort a
number of events by this order, the process changes the order from what it
was before, but not in the order established in the custom list, nor
alphabetical.
I'm working in Windows XP, Excel 2000.

Hi,

is the custom list Jan to Dec or something else. Could you please post some
more details i.e actual values?

Thanks,
Matt

"gitttep" wrote:

thanks for taking the time to answer my bulletin. I meant to imply that ,
once I set up the custom list, I also clicked on it in the Options box when
I wanted to perform the sort. No luck! Any other suggestions? Thanks.

"Matt Lunn" wrote:

Hi,

Click the Options button on the Dort dialog box (DataSort) Your custom list
should appear in the First Key Sort Order drop down box. Choose it and click
OK.

HTH,
Matt

"gitttep" wrote:

I have established a custom list using the three first letters of the 12
months, but need a sorting order to correspond to the Federal fiscal year,
i.e., starting with "Oct" and ending with "Sep." This list in this order has
been saved under the custom list component of Excel. When I want to sort a
number of events by this order, the process changes the order from what it
was before, but not in the order established in the custom list, nor
alphabetical.
I'm working in Windows XP, Excel 2000.

The list starts with October and ends with September:
Oct
Nov
Dec
Jan
Feb
etc.

"Matt Lunn" wrote:

Hi,

is the custom list Jan to Dec or something else. Could you please post some
more details i.e actual values?

Thanks,
Matt

"gitttep" wrote:

thanks for taking the time to answer my bulletin. I meant to imply that ,
once I set up the custom list, I also clicked on it in the Options box when
I wanted to perform the sort. No luck! Any other suggestions? Thanks.

"Matt Lunn" wrote:

Hi,

Click the Options button on the Dort dialog box (DataSort) Your custom list
should appear in the First Key Sort Order drop down box. Choose it and click
OK.

HTH,
Matt

"gitttep" wrote:

I have established a custom list using the three first letters of the 12
months, but need a sorting order to correspond to the Federal fiscal year,
i.e., starting with "Oct" and ending with "Sep." This list in this order has
been saved under the custom list component of Excel. When I want to sort a
number of events by this order, the process changes the order from what it
was before, but not in the order established in the custom list, nor
alphabetical.
I'm working in Windows XP, Excel 2000.