On Thu, 2 Feb 2006 11:02:58 -0600, mphell0
wrote:


Thanks Ron but I found an easy way to do it without using helper
columns.
Maybe this will help others in the future. In ToolsOptionsCustom
Lists
you can create a list of values and how you want them sorted. I put
in
1st, 2nd, 3rd etc. into this list. Then when I went to do my sort, in
the sort
menu there is a tab called "options" that allows you to select a custom
list to
define the sort order. This worked perfectly.

I'm glad that worked for you. Of course, you need to have all the items in the
list, or it may not sort properly. Also, I'm not sure (you should check it if
it may be an issue), if custom lists are stored with the workbook. That could
be an issue if you move the workbook to another machine.
--ron