Social Security Numbers without dashes

[MARKEGANDERSON]

Hello Guys How can I display SSNs without the dashes?

Would it be in format cells option?

 

[Tetra201]

Try formatting the cells as 000000000

 

[MARKEGANDERSON]

thanks tried that, right click cell, format, custom,000000000..did not work

 

[Tetra201]

If your cells are formatted as General and you see the dashes, then the SSNs are text strings.
In this case, formatting would not work -- try using the following formula:

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

 

[MARKEGANDERSON]

Thanks this works when I reference the cell. How can I incorporate the existing formula =IFERROR(INDEX(DTS_SSN,(MATCH(TASS_DTS_ID,DTS_ID,0))),"") with
=TEXT(SUBSTITUTE(A1,"-",""),"000000000")