Excel Sorting

Posted on 1999-07-27
Medium Priority
Last Modified: 2013-12-18
Is there a way to sort a column that contains "numbers" with more than one decimal?  I'm trying to sort numbers from an outline such as:

1.0  1.12  1.12.1  2.12  2.1.13

It seems that Excel recognizes numbersd as one decimal and doesn't have the ability to sort numbers from an outline format.  Is that correct?

I have moved the data into Microsoft Word and am trying to sort that data in a table.  It seems to be getting closer to the correct results.

Thanks for any suggestions!!
Question by:lduning
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Expert Comment

ID: 1120050
It will work normally in Word!! just put each outline in a separate row then select the whole column and click sort!

Accepted Solution

ghassan99 earned 600 total points
ID: 1120051
This is considered as a string when u add more than one decimal (.) point in Excel, what I suggest u do is add preceding 0's eg.  002.1.1, and for number that has one decimal point u can add an extra point 002.1. or just add a 0 eg.  002.1.0.  It will work in Word easily without extra point for one point outlines, but u have to preced it with extra 0's for it to sort logically, coz this is not considred as a number to the system its plain text, so 12.2.1 will come before 2.2.3 for example, but 012.2.1 will come after 002.2.1

Author Comment

ID: 1120052
Sounds like my suggestion of moving the data to Word is the best option.  Thanks.

Expert Comment

ID: 1120053
no not necessarily...coz excel assumes integers or numbers for its cells....when u enter one point it will assume its an integer while Word wont do that...the only difference is being forced to add an extra deciaml point in Excel so it wont be mistaken with a number or an integer.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question