markedback
MIS
I have a table that needs to be sorted by the ID number. Some of the ID numbers are 5-digit and some are 9-digit. When I try to sort the table currently, all the ID numbers sort in the order of the number in the first digit position irrespective of the number of digits.
I would like to sort the table by the ID number with the 5-digit numbers clubbed together and the 9-digit numbers clubbed together.
Please help.
Thanks,
Mark.