Sorry, not too clear. Try again:

Some cells contain data like 13640681, formatted Special, SSN. Some files
contain data like 013-64-0681. These variants may occur for the same
individual. I need to sort the data to bring all of any individual's records
together, hence I need to convert all of one kind or the other to a format
that makes them all formatted the same.

I hope that's a bit clearer!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Dave Birley" wrote:

I have some mixed data formatting in a column, SSN. Some of it is in the
format Numeric, then formatted 000-00-0000, and some of it is in the Format
"123-45-6789". I need to make it all alike -- how do I proceed?
--
Dave
Temping with Staffmark
in Rock Hill, SC