Social Security Number

[montagu]

How do you convert a social security number from text to a number? Is there a way to convert an entire column?

[swatsp0p]

Assuming your SS numbers are in the format of 123-45-6789,
Try doing a Find/Replace

Find "-" (don't enter the " marks)
Replace with (leave this blank)

Does this work for you?

Bruce

[montagu]

I treid using your Find and Replace, but it did not do the trick. Thanks.

[swatsp0p]

Hmmm, worked for me. What happened when you tried it?

Your Find/Replace should look like the attached .jpg....

Bruce