How do you change sort defaults for combined text number & hyphen.
I'm trying to sort an array of part numbers such as (3000, 3000P, 3000-10,
3000-10P, 30000P) and would like them to appear in that order. But I see
that Excel ignores hyphens, which is part of the problem. Is there anyway I
can change the data sorting defaults so the part numbers appear is this order?
|