AnsweredAssumed Answered

Value List numerical sort

Question asked by DustFairy on Feb 22, 2015
Latest reply on Feb 22, 2015 by philmodjunk


Value List numerical sort


I'm trying to sort a value list in ascending numerical order.  I want to sort by the second field which is usually just a number but occasionally has alpha characters.

I don't seem to be able to get the list to sort numerically even if all values are numeric.  I know I have seen the answer to this in the forum but can't find it again.  I'm pretty sure it has to do with the field type but I've tried both text and number and neither works.

Sorry to  be asking questions that have already been answered in the forums.