Thread: Sorting 1, 2, 10, 20 to 1, 10, 2, 20
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Sorting 1, 2, 10, 20 to 1, 10, 2, 20
Hi Caroline,

Say your data is in column A.
Insert a helper column and in B1 put ="."&A1 and drag
down to the end of your data, this will convert it to .1, .2, .10,
..202 etc.
Then sort on column B ascending, and then delete column B

HTH
Martin


Reply With QuoteReply With Quote