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.