View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lt. Bonifacius Lt. Bonifacius is offline
external usenet poster
 
Posts: 5
Default Simple sort issue

Hi Eloise!

The problem is that Excel is sorting the information like text not like
numbers. You have to use the Text-To-Columns function in order to separate
the information and then sorting.

1. Select the data you want to transform i.e. the column where the series is.
2. Then go to the "Data" menu then clic on "Text to columns..."
3. Make sure Delimited is selected, then clic next.
4. In Step 2 of 3 in Delimiters select the option "Other" and in the box
write "." (This is telling Excel that the information between "." should be
separated).
5. You can see in the data preview how would your data look like.
6. You can clic next or either go to the next step and select a data type
for each column.
7. Once your information is separated in columns select all the information
or cell in the information and go to to the "Data" menu the go to "Filter"
and clic "Automatic Filter".
8. Select each arrow from left to right and clic in "sort ascending".
Note. The data in the cells must be formatted as numbers.

Hope it works for you.