LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to sort number properly in excel? oli merge Excel Discussion (Misc queries) 5 October 29th 07 05:30 PM
Can you sort by most to least often recurring number in Excel? Jilly Excel Worksheet Functions 2 September 18th 07 08:36 PM
Sort by number not by letter (C1, A2, B3, D4) dukemeiser Excel Discussion (Misc queries) 3 May 5th 06 02:40 AM
how can I sort alphanumeric entries by number in excel beasleyb Excel Worksheet Functions 1 October 27th 05 10:17 PM
How do you sort words in Excel by the number of letters in a word Kinger New Users to Excel 2 May 2nd 05 11:42 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"