N
NH
Please help!!!
Is there a way to change SSN format from "123-45-6789" to "123456789"?
Is there a way to change SSN format from "123-45-6789" to "123456789"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
NH
More information added...
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.
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
Edit|replace
what: - (hyphen)
with: (leave blank)
replace all
Then give it a nice custom format: 000000000
N
NH
Your suggestion is so helpful...thanks a lot!
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