J
jr
perhaps the problem is that the hyphenated numbers are
treated as TEXT and numbers come before TEXT.
Try changing the range that the numbers are entered (and
sorted) to TEXT via cell format. Now the numbers that
appear as 1234 will be treated like text
and "alphabetize" correctly.
treated as TEXT and numbers come before TEXT.
Try changing the range that the numbers are entered (and
sorted) to TEXT via cell format. Now the numbers that
appear as 1234 will be treated like text
and "alphabetize" correctly.