Thread: how to sort anything that looks like a number as a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default how to sort anything that looks like a number as a number
Hi Cyndi,

Since XL2002. possibility exists in Sort Options ...

Selection.sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _

DataOption1:=xlSortTextAsNumbers

HTH
Cheers
Carim

Reply With QuoteReply With Quote