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: 1
Default Sort numbers by the first integer


I have a column of numbers that I sort based on the first integer. For
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks.


--
skiman123321
------------------------------------------------------------------------
skiman123321's Profile: http://www.excelforum.com/member.php...o&userid=36890
View this thread: http://www.excelforum.com/showthread...hreadid=566074

 
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 can you get Excel to sort numbers with alpha suffixes? 1234A boneified5 Excel Discussion (Misc queries) 1 May 17th 06 04:02 PM
Auto insert page breaks in Excel, based on a sort of numbers peterc89 Excel Discussion (Misc queries) 0 November 9th 05 03:41 PM
sort "numbers" with decimals Melissa Excel Discussion (Misc queries) 4 September 2nd 05 02:28 PM
Sorting numbers and text separately Tim C Excel Discussion (Misc queries) 8 July 21st 05 12:53 AM
How to sort random numbers in columns webehere Excel Discussion (Misc queries) 3 January 15th 05 12:24 PM


All times are GMT +1. The time now is 08:38 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"