2007 excell

I have data of hundrit of serial numbers of equipment that some start as ZERO, some as other number, some as letter. I don't want top change it to text because I need to sort it by number. How can I show the 0 as 1st number in the serial numbers I need to (to rest I don't want to add zero). To me 0 has a meaning because equipment that is 01234 is a different equipment from equipment 1234 (two different pcs).

Please help.