Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
?
Lv 7
? 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?

Update:

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

3 Answers

Relevance
  • 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.

  • Outhval
    Lv 7
    6 years ago

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

Still have questions? Get your answers by asking now.