Data won't sort in numerical order?
Posted by Julie on April 26, 2001 11:32 AM
Help - I'm having a problem that sounds basic but I can't seem to see what I am doing wrong. I have a list of employee numbers that I need to sort in numeric order. Our old employee numbers were 9 digits long, with the first 3 digits being zeros. Our new numbers are still nine digits long, but begin w/ "150". When I try to sort the list, some of the 150 beginning numbers go to the beginning of my listing and some to the end??? Any ideas what I am doing wrong?