I want to sort my Bill of Material by ascending part number. but when i got to sort and do sort by Part # and click OK i get this(Screenshot below). I want by bill sorted by  ascending part number not by ascending left most digit. Is this able to be done without manually reordering the BOM. To be clear on what i am trying to accomplish I added a screenshot of what i want on the left.