Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to sort number properly in excel? | Excel Discussion (Misc queries) | |||
Can you sort by most to least often recurring number in Excel? | Excel Worksheet Functions | |||
Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
how can I sort alphanumeric entries by number in excel | Excel Worksheet Functions | |||
How do you sort words in Excel by the number of letters in a word | New Users to Excel |