View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ezil ezil is offline
external usenet poster
 
Posts: 43
Default sorting numerical data

I need to sort a column say "c" which contains numerical data. When i press
"a to z sort" button the numerical data is sorted as alphabetical data i.e
it ignores positive and negative signs and after 10, the value 100 comes
and 20 then -20 then 200 like this. How to sort this data in ascending or
descending order?