Hi,
In my table have serial numbers from 1 through 99999 (example 34, 989, 12938 .....etc) but when I put them in ascending order it will put them in 12938, 34, 989 ... order. I think it sees the numbers as 12938, 34000, 98900 .... . I would like to place 000's in front of the 2/3/4 digit numbers so it reads them as their true numbers. The data type for the serial numbers is text (which I need to keep).
Does this make any sense? Can anyone help? Thanks in advance.
In my table have serial numbers from 1 through 99999 (example 34, 989, 12938 .....etc) but when I put them in ascending order it will put them in 12938, 34, 989 ... order. I think it sees the numbers as 12938, 34000, 98900 .... . I would like to place 000's in front of the 2/3/4 digit numbers so it reads them as their true numbers. The data type for the serial numbers is text (which I need to keep).
Does this make any sense? Can anyone help? Thanks in advance.