View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AnitaG AnitaG is offline
external usenet poster
 
Posts: 5
Default Number sort in Excel

What I have is a list of assets named like this -
Public1, Public2, . . . Public10, Public11, etc. and when I need to do
inventory it is hard to go off of the spreadsheet because of the order in
which these things get sorted. It comes out Public1, Public10, Public11, . .
..Public19, Public2, Public20, etc. Is there a way that I can get it to go in
1,2,3 order since it would make it so much easier to go down the list instead
of having to hunt for the asset I need at the time? I'm sure it is an easy
solution but it escapes me. Thanks for any help.