Social Security Number
 

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


--
montagu
------------------------------------------------------------------------
montagu's Profile: http://www.excelforum.com/member.php...o&userid=15227
View this thread: http://www.excelforum.com/showthread...hreadid=382531

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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382531

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


--
montagu
------------------------------------------------------------------------
montagu's Profile: http://www.excelforum.com/member.php...o&userid=15227
View this thread: http://www.excelforum.com/showthread...hreadid=382531

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

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

Bruce


+-------------------------------------------------------------------+
|Filename: Find-Replace.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3542 |
+-------------------------------------------------------------------+

--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=382531