Please help!!!

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

More information added...

"NH" wrote:

Please help!!!

Is there a way to change SSN format from "123-45-6789" to "123456789"? I have a very long list with SSN in "123-45-6789" format, but need to change to the format without the dash "123456789".

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.

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

Then give it a nice custom format: 000000000



NH wrote:

Please help!!!

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

--

Dave Peterson

Your suggestion is so helpful...thanks a lot!

"Dave O" wrote:

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.

Thanks so much for your very helpful suggestion.

"Dave Peterson" wrote:

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

Then give it a nice custom format: 000000000



NH wrote:

Please help!!!

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

--

Dave Peterson