Same problem Is there a seperator that will allow a new list in options new
list. What can be done to get true numerical sorting. Not familar with helper
columns. Also want to be able to convert action to macro.
Thanks


"Pete_UK" wrote:

I think your numbers are really text values that look like numbers, for
it to sort in the way you say.

Pete

Dawn wrote:
help! I can't seem to get excell to sort in real numerical order ie 1, 2, 3,
4, 5 and NOT 1, 10, 100, 2, 20, etc. my data is definatatly sorted in
number format
Using excell 2003
hope someone can help
thanks
Dawn