| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Social Security Numbers & Leading Zeros | Excel Discussion (Misc queries) | |||
| Social Security Number format | Excel Worksheet Functions | |||
| social security numbers | Excel Worksheet Functions | |||
| How can I compare 2 sets of Social Security #'s and Identify dupes | Excel Discussion (Misc queries) | |||
| (social security number) 000-00-0000 to 000000000 | Excel Discussion (Misc queries) | |||
Hybrid Mode
