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
 
Top