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: 661
Default Want to sort a list of numbers by last two digit...

Hi,
I have a long list of numbers ie 1.2003 to 7.2007 that are not in order how
can I sort them so I get them in month and year order. When I do a sort know
I get them in Month and year order ie
1.2003
2.2004
3.2005
and not
1.2003
2.2003
1.2004
2.2004
Cheers Paul.

Paul.
 
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
entering 16 digit numbers - last digit turns to zero dreamer New Users to Excel 4 May 9th 09 01:04 AM
List Sorts Numbers By First Digit, Rather Than The Whole Number. [email protected] Excel Discussion (Misc queries) 3 April 10th 07 10:26 AM
sort numbers based on initial digit. Andyd Excel Discussion (Misc queries) 2 June 28th 05 01:20 PM
I wish to change the last digit in a list of random numbers. To a. kingie Excel Worksheet Functions 5 February 28th 05 08:17 PM
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. [email protected] New Users to Excel 1 February 18th 05 12:59 AM


All times are GMT +1. The time now is 09:37 AM.

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

About Us

"It's about Microsoft Excel"