Results 1 to 2 of 2

Thread: Sorting (2000)

  1. #1
    New Lounger
    Join Date
    Dec 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting (2000)

    Is there any way to sort a column of part numbers that contain both numbers and text in numerical order? For example, when the numbers 5, 109G, 109 and 777 are sorted in ascending order, the 109G is last on the list, not the next number after 109. Any suggestions?

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

    Re: Sorting (2000)

    I think that the best way would be to convert all of the cells to Text. You should be able to do this by just selecting the column and doing a Format/Cells and select Text.
    Legare Coleman

Posting Permissions

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