M
montagu
How do you convert a social security number from text to a number? I
there a way to convert an entire column
there a way to convert an entire column
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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?
Bruc
Try doing a Find/Replace
Find "-" (don't enter the " marks)
Replace with (leave this blank)
Does this work for you?
Bruc
M
montagu
I treid using your Find and Replace, but it did not do the trick
Thanks
Thanks
S
swatsp0p
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 |
+-------------------------------------------------------------------+
Your Find/Replace should look like the attached .jpg....
Bruce
+-------------------------------------------------------------------+
|Filename: Find-Replace.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=3542 |
+-------------------------------------------------------------------+