Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Aug 2003
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sort order (excel 2003)

    how to sort 1-14 in following order please
    9
    8
    7
    6
    5
    4
    3
    2
    14
    13
    12
    11
    10
    1

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort order (excel 2003)

    Convert numbers to text using the =TEXT(A1,"#") function and sort in descending order.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sort order (excel 2003)

    Two methods:

    1. Format the range of cells as Text before entering the numbers. Enter the numbers 1 to 14 in any order, then sort descending.

    2. Enter the numbers as '1, '2, etc., up to '14. The apostrophes won't be displayed, but they force Excel to treat the numbers as text. Then sort descending.

  4. #4
    Star Lounger
    Join Date
    Aug 2003
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sort order (excel 2003)

    thank you.

Posting Permissions

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