Hi

Why not break the list to 2 columns?

1. Copy the same column and paste to right;
2. Select first column;
3. Replace " -*" with nothing;
4. select the second column;
5. Replace "*- " with nothing;
6. Sort by the order of the first colmn


"JSpence2003" wrote:

I have a list of distances, that when I pull into a Pivot Table it sorts them
by the "spelling" of the number, I have tried changing the type of field
(Number, General, Text, etc). Nothing seems to work. Any suggestions?

0-5 miles
10-15 miles
105-110 miles
150-155 miles
15-20 miles
175-180 miles
20-25 miles
25-30 miles
30-35 miles
35-40 miles
40-45 miles
45-50 miles
50-55 miles
5-10 miles
60-65 miles
65-70 miles
85-90 miles
Non-Responders