Sort Order vs Comparison Order

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a list on an Excel spreadsheet which I have
sorted. Among other entries, the list has "Con"
and "CWC". When I sort, it places "Con" before "CWC".

In VB, I am comparing the fields in the sorted list. In
the VB comparison statement, it sees "CWC" as being less
than "Con" (presumably because the Hex value for the "o"
is greater than the Hex value for the "W").

Is this correct? And is there any way to make the two
look at the data in the same way?
 
I can't reproduce your problem. Can you post the "VB comparison
statement" to which you refer?

Alan Beban
 
Hi!

If you have a non-ASCII sort to do, you can use the Options button o
the sort dialogue box to good effect. It gives you access to the Custo
Lists you can set up (Tools|Options|Custom lists) and thei
idiosyncratic orders. (Look at the days of the week...) First set u
the list (see help). Then use it.

Al
 
Back
Top