Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Location
    Arizona, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting a Column (Excel 2000 SR1)

    Here is a portion of the document I am trying to sort the first column numerically. I tried the suggestion of clearing the formatting and the numbers with the leading zero(s) were "General". I changed them to text, and the same problem persists.
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Sorting a Column (Excel 2000 SR1)

    Jan

    Would this example help?

    I sorted on column B, the formulas.

    Wassim
    Attached Files Attached Files
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Aug 2001
    Location
    Arizona, USA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting a Column (Excel 2000 SR1)

    Sorting my Column B does not help because I am look through the numbers in Column A and Column B does not put Column A in numerical order.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting a Column (Excel 2000 SR1)

    As I suspected, some of the values in column A were entered as text, and some were entered as numeric values. The attached sheet converts them all to text, and they now seem to sort correctly.
    Attached Files Attached Files
    Legare Coleman

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Sorting a Column (Excel 2000 SR1)

    Jan

    I thought that you would look at the formula in Column B and figure out that you need to change the cell values to numeric values vs having them all mixed. You could insert a new column and add the formula and then sort on that column and then delete the inserted column, and what you end up with is a sorted worksheet the way you want it.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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