Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting numbers as Text | New Users to Excel | |||
SORTING TEXT AND NUMBERS | Excel Worksheet Functions | |||
Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
Sorting order - text and numbers | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |