Don't change them to text. Change them to numbers. Remove all of the dashes
with Search and Replace. Then apply the special format for Social Security
numbers.


On Tue, 25 Jan 2005 05:45:02 -0800, "Precious Pearl" <Precious
wrote:

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.