Hi, Carim:

I can't find the Sort Options that you list below. How do I get to it? When
I click on Data/Sort... then the Sort box comes up. I need to sort by three
criteria, with the third being to sort by the column that contain the numbers
stored as text. I select the criteria and sort orders, then when I click on
the Options button the only choice showing for the First key sort order is
"Normal" (the other sort orders are for days of the week and months). There
is an option for Case sensitive, which I leave unchecked. For Orientation I
select top to bottom. There are no other options available. How do I get to
the options you suggested? Thanks for your patience and help.



"Carim" wrote:

Hi Cyndi,

Since XL2002. possibility exists in Sort Options ...

Selection.sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _

DataOption1:=xlSortTextAsNumbers

HTH
Cheers
Carim