Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sort Options (2000)

    I have a spread sheet that we use to trace our Purchase Orders. The first column which is the purchase order # is our main sort value ex. (J-888). The problem is that once we got to 1000 - the result of us resorting by the PO column moved all the PO's above 999 to the top of the spreadsheet. How can I keep them in order from 1 - 2000?
    lynndelap

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

    Re: Sort Options (2000)

    You could change all of the (J-888) numbers to (J-0888). You can do this easily by selecting those and using Edit/Replace to replace the - with -0. If all of the IDs begin with J- (ie. there are no other letters used), then another option would be to insert another column and extract the numeric part of the ID as a numeric value and sort on that column.

    BTW, how did you keep the numbers 1 through 99 from causing the same problem?
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort Options (2000)

    I started at 200, therefore didn't have the issue of going from 99! <img src=/S/clever.gif border=0 alt=clever width=15 height=15> Thank you for the fix of adding a 0!
    lynndelap

  4. #4
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort Options (2000)

    Adding the 0 did not work, it just kept the sort with the 01000 after the 0999.
    lynndelap

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Sort Options (2000)

    The ones >=1000 do not need the leading zero...

    Steve

  6. #6
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sort Options (2000)

    OKAY, I WILL TRY THIS AGAIN. THANK YOU. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>
    lynndelap

Posting Permissions

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