SSN Format

G

Guest

Please help!!!

Is there a way to change SSN format from "123-45-6789" to "123456789"?
 
D

Dave O

How about a search and replace? Search for the dash and replace with
nothing. Or, you could use a couple of text parsing functions in a
formula:
=left(A1,3)&mid(A1,4,2)&right(A1,4)
.... where A1 contains the SSN.
 
D

Dave Peterson

How about selecting the range.
Edit|replace
what: - (hyphen)
with: (leave blank)
replace all

Then give it a nice custom format: 000000000
 
G

Guest

Thanks so much for your very helpful suggestion.

Dave Peterson said:
How about selecting the range.
Edit|replace
what: - (hyphen)
with: (leave blank)
replace all

Then give it a nice custom format: 000000000
Click to expand...
 

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

Some of my SSN's are being treated as formulas 12
07 Pivot Table side by side row labels 3
Copying SSNs to new format 6
Finding Text String Within A String With A Formula 5
Masking Characters 6
Formatting a Combo box 12
Sheet Comparison 1
How do I create an Access form that blocks 1st 5 #s of SSN? 1

Top