social security numbers

G

Guest

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

Guest

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
Social Security Number format 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Old digital copier machines store what was copied on an internal hard drive! 8
How to remove dashes in Social Security number 15
How do I sum here using criteria there? 10
Need to change numbers with dashes to numbers with no dashes 3
Calculating Social Security 3

Top