I am having problems with sorting social secuirity/tax id numbers that were
dropped into excel from several different sources. Some of the ss/tax id
numbers have dashes and some do not. Some of the ss/tax id numbers are
missing leading zero's. I am not able to change all of them into a text
format.

How can I formatt them all so they will sort properly?

Thanks for any assistance out there.