Use the same number of digits for each number portion:

01A00001
01A00002
02A00001
02A00003
02X00009
03A00001
69A50001
70A00007


xorex wrote:

Hi, I am trying to make a list of numbers which will automatically sort in a
number/letter/number format.
IE; 1A1;
1A2;
2A1;
2A3;
2X9;
3A1;
69A50001;
70A7;
etc, etc.
Any help appreciated.
Mike.

--

Dave Peterson