Seems to me they are in order from smallest to biggest. What order do you want them to be in?
You could maybe set them in an user defined order if you use strings or constants instead of length expressions...
I tested this and found that when you're using the KRX file with the Part Family that the order in the spreadsheet does not seem to matter. What I was unable to do is maintain the fractional values from the spreadsheet to the dialog - it converted them to decimal. What 'Format' did you use on the cells with the fraction values in Excel to maintain the fraction values (I used fraction) and how are you using these values in NX (i.e., to maintain the fraction values in the dialog)? I'm wondering if the issue you have found is a string vs number issue, in that the KRX functionality is able to sort values that are numbers but not text.
These are exisitng Bolts from the Machinery library, from Siemens.
I changed the format in the Excel sheet to Fractions , from text, it seems it did not make a difference in the order. after I did the save.
I would like to retain the fractional data in the dialogue box.
Thanks for the help.
On closer inspection it looks like the LENGTH column in the spreadsheet drives the LENGTH attribute in the part family template - which is a string attribute. I suspect that's where the problem lies, because the fractions aren't converted to their number equivalent, NX simply reads them in the order they are defined in the spreadsheet (or perhaps ordered by some other attribute or expression in the KRX), rather than order them ascendingly. You could try replacing the LENGTH string attribute with a LENGTH number attribute (as you can't modify the Dimensionality), but as you state - you want to keep the fraction value in the dialog so perhaps that's not a solution. Interestingly, I can't recreate this from scratch - Excel tries its hardest to convert a fraction to a decimal, unless I place quotations around the values (or define the format as Fraction), so consequently I either get numerical values in my test part (even when the cell format in Excel is set to Fraction) or the list now shows quotes around the fractions.