SSN Format

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
 
N

NH

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
 
Top