Thread: How can I sort by numbers and not text?
View Single Post
  #1   Report Post  
Arsenal
 
Posts: n/a
Default How can I sort by numbers and not text?

I'm trying to sort my list (column B) but it sorts it like this:

A1
A10
A2

how do I sort it like this:

A1
A2
A10

without padding the numbers (A01, A02, etc)?

MS Word has sort by numbers but Excel doesn't seem to have that
option.

Thanks.


--
Arsenal
------------------------------------------------------------------------
Arsenal's Profile: http://www.excelforum.com/member.php...o&userid=27417
View this thread: http://www.excelforum.com/showthread...hreadid=469325

Reply With QuoteReply With Quote