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.
|