+ Reply to Thread
Results 1 to 5 of 5

sort "numbers" with decimals

  1. #1
    Melissa
    Guest

    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, ....

  2. #2
    NlCO
    Guest
    Insert two Columns at the right of the numbers.
    Select the range of numbers i.e. "A:A"
    Then go to DATA>> Text to Columns >> Delimited
    Uncheck all checked and then select "Other and put a "." in the space provided (without the "")
    Then Click Finish.
    You'll have on B:B all the data before the point.
    In Colum C Row 1 you can put =A1&"."&B1 to get the numbers together again.

    Saludos

    NlCO

  3. #3
    Registered User
    Join Date
    09-16-2003
    Location
    Waiau Pa NZ
    Posts
    81
    you need to split the values first and then sort by the decimals

    to split them use <data> <text to columns> <delimited> <other> . <destination> next to your chapter numbers.
    then sort by the column with the decimals

    have fun
    Greetings from New Zealand
    Bill Kuunders

  4. #4
    Bernd Plumhoff
    Guest

    RE: sort "numbers" with decimals

    Hello Melissa,

    http://www.bplumhoff.de/software/sort_chapter.xls

    is a sample spreadsheet with a UDF in it which solves this.

    HTH,
    Bernd

  5. #5
    Dave Peterson
    Guest

    Re: sort "numbers" with decimals

    Another option would be to use:

    4.01, 4.02, ...

    (or 4.001, 4.002, ... if you can hit triple digits)


    Melissa wrote:
    >
    > 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, ....


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1