How do you convert a social security number from text to a number? Is there a way to convert an entire column?
How do you convert a social security number from text to a number? Is there a way to convert an entire column?
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
Bruce
The older I get, the better I used to be.
USA
I treid using your Find and Replace, but it did not do the trick. Thanks.
Hmmm, worked for me. What happened when you tried it?
Your Find/Replace should look like the attached .jpg....
Bruce
Last edited by swatsp0p; 06-27-2005 at 12:18 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks