I'm not sure what form tax id's are supposed to take, but
to format all the SSN's correctly, try:
=TEXT(REPT("0",9-LEN(SUBSTITUTE(A1,"-","")))&A1,"000-00-
0000")
HTH
Jason
Atlanta, GA
-----Original Message-----
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.
.
|