View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Sorting numbers the common sense way excell03

Hi,
convert text to numbers
do Copy, paste special values


"dlaplant" wrote:

How do I get these rows sorted numerically

1705
17350
20028
20028
2053
220
3839
4077
4077
4646
4673
4673

as you can see it is sorting by the first digit without regard to its actual
value. This is totally frustrating.