Remove Dashes from Social Security Numbers
 

How do I remove the dashes from SSN's on a spread sheet? They are NOT setup
as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX
and I still need the 0's (zeroes) to show.

Remove Dashes from Social Security Numbers
 

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

and format as 0000000000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"catrose" wrote in message
...
How do I remove the dashes from SSN's on a spread sheet? They are NOT
setup
as '111-11-1111 I also have a lot of SSN's that start with
00X-XX-XXXX
and I still need the 0's (zeroes) to show.

Remove Dashes from Social Security Numbers
 

how about using SUBSTITUTE

--
Don Guillett
SalesAid Software

"catrose" wrote in message
...
How do I remove the dashes from SSN's on a spread sheet? They are NOT
setup
as '111-11-1111 I also have a lot of SSN's that start with
00X-XX-XXXX
and I still need the 0's (zeroes) to show.

Remove Dashes from Social Security Numbers
 

Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000

---------------
mama no teeth

"catrose" wrote:

How do I remove the dashes from SSN's on a spread sheet? They are NOT setup
as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX
and I still need the 0's (zeroes) o show.

Remove Dashes from Social Security Numbers
 

That worked perfectly. Thank you!!!!

"Nobody" wrote:

Edit | Replace | Find What:- | Replace With: "leave it blank" | click Replace
All
Format | Cells | Number tab | Custom | Enter 000000000

---------------
mama no teeth

"catrose" wrote:

How do I remove the dashes from SSN's on a spread sheet? They are NOT setup
as '111-11-1111 I also have a lot of SSN's that start with 00X-XX-XXXX
and I still need the 0's (zeroes) o show.