Candidate Sorting Issue

Hello, Have noticed that when sorting the Candidate ID by ascending, it groups 8 with 80 and 800. Surely 008 should not even be on the same page as 800. So the candidate ID number needs to be treated as having zeros in the front before sorting. I want candidate 799 to be one record away from candidate 800. Thank you.