SSN Format

C

Chip Pearson

Leslie,

Try something like

=SUBSTITUTE(A1,"-","")


Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
D

Dave Peterson

And if the dashes are inserted because the number is formatted as
Format|Cells|Number tab|Special category|SSN, just format the cell as General.
 

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

Need to change numbers with dashes to numbers with no dashes 3
Preserve cell formatting as SSN 2
Can't figure this out 1
remove dashs from social security numbers 4
Formatting the SSN 9
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
Leading zero's missing for SSN numbers... 3
How to remove dashes in Social Security number 15

Top