Lv 7
Amy asked in Computers & InternetSoftware · 6 years ago

In Excel how do I sort a column so the numbers run properly; 1 2 3 4 5 6 and so on?


When I use the sort tool it's sorting it weird like; 1 10 100 101 102 etc.

3 Answers

  • IXL@XL
    Lv 7
    6 years ago

    Your numbers are formatted as Text (or have a leading ' )

    Either format as General or Number and resort, or if they must be text use Data>Sort >OK then on Data warning submenu select Sort anything that loks like a number as a number option .

  • Edward
    Lv 7
    6 years ago

    Highlight the data range.

    On the toolbar, select Data

    Then Sort

    Then Ascending.

  • 6 years ago

    Follow Edward's instructions, as that is the way to do it.

Still have questions? Get answers by asking now.