View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JSpence2003 JSpence2003 is offline
external usenet poster
 
Posts: 13
Default Sorting (Numbers with Text)

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