LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Melissa
 
Posts: n/a
Default sort "numbers" with decimals

I've got chapter numbers in one column which goes: 4.1, 4.2, 4.3...., 4.11,
4.12....
How can I sort it by the numbers on the right of the decimal point instead
of getting: 4.1, 4.10, 4.11, 4.12, ....4.2, 4.20, 4.21, ....
 
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 do I sort hexidecimal numbers in an excel spreadsheet? Jane Martin Excel Discussion (Misc queries) 2 July 18th 05 07:45 PM
How do I sort letters before numbers in Excel? RiverGirl Excel Discussion (Misc queries) 4 May 27th 05 04:09 PM
Converting imported numbers to decimals (rather than /100) Frustrated Excel user Excel Worksheet Functions 2 April 5th 05 05:46 PM
Numbers won't sort correctly. FernW Excel Discussion (Misc queries) 10 April 1st 05 01:29 PM
Numbers won't sort correctly. FernW Excel Discussion (Misc queries) 1 March 3rd 05 02:46 PM


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