social security numbers

J

Jean

How do I change social security numbers so that all the dashes are removed?
thank you for your help in advance.
Jean
 
J

Jean

Thank you, I did look there first but cannot understand how to convert the
format from dashes to no dashes, even after looking at that section of the
help. I have 800 records to convert and do not want to have to go in and
delete all the dashes if I can do it an easier way!
 
D

Dave Peterson

Maybe just select the range with the SSNs with dashes and

Edit|replace
what: - (hypen)
with: (leave blank)
replace all

Then format it as a SSN (format|cells|number Tab|special|SSN)

as a formula that returns text:
=substitute(a1,"-","")
or as a formula that returns a number:
=--substitute(a1,"-","")
 
D

Don Guillett

try this macro after selecting your range with the numbers

Sub deletedash()
For Each c In Selection
c.Value = Application.Substitute(c, "-", "")
Next
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Cells - Custom 1
Calculating Social Security 3
How do I sum here using criteria there? 10
How to remove dashes in Social Security number 15
Line Numbers Will Not Show 0
Need to change numbers with dashes to numbers with no dashes 3
Social Security Number format 1
custom format changes to special 0

Top