+ Reply to Thread
Results 1 to 3 of 3

How do I create a numbering format in excel?

  1. #1
    Colleen
    Guest

    How do I create a numbering format in excel?

    I need for Excel to sort by the numbering system 1.1, 1.2, 1.3, 1.4, 1.5,
    1.6, 1.7, 1.8, 1.9, 1.10, 1.11 and so on. It does not seem to recognise this
    numebring.

    I have tried to creat it under the custom button but it still doens't work -
    any ideas would be appreciated.

  2. #2
    Peo Sjoblom
    Guest

    Re: How do I create a numbering format in excel?

    Have you tried to sort? If so what did you get?

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "Colleen" <[email protected]> wrote in message
    news:[email protected]...
    >I need for Excel to sort by the numbering system 1.1, 1.2, 1.3, 1.4, 1.5,
    > 1.6, 1.7, 1.8, 1.9, 1.10, 1.11 and so on. It does not seem to recognise
    > this
    > numebring.
    >
    > I have tried to creat it under the custom button but it still doens't
    > work -
    > any ideas would be appreciated.



  3. #3
    bj
    Guest

    RE: How do I create a numbering format in excel?

    Excel is going to try to recognize your system as numbers where 1.11 is less
    than 1.2.
    You could force thenm to be text, and have a special list for sorting, but
    numbers as text have there own issues.

    Could you enter the data as 1.01,1.02, etc This would sort.
    Can you have a helper column to do the true sorting from.
    with
    =if(mod(round(A1*100,0),10)=0,Floor(A1,1)+mod(A1,1)/10,A1)
    copy this down to the end of your data

    "Colleen" wrote:

    > I need for Excel to sort by the numbering system 1.1, 1.2, 1.3, 1.4, 1.5,
    > 1.6, 1.7, 1.8, 1.9, 1.10, 1.11 and so on. It does not seem to recognise this
    > numebring.
    >
    > I have tried to creat it under the custom button but it still doens't work -
    > any ideas would be appreciated.


+ 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