SS#

  • Thread starter Thread starter colleen
  • Start date Start date
C

colleen

I have an excel worksheet that contains SS# numbers in
it. I have recently found that others entering in the
sheet don't use the auto foramt they maually type in the
hyphen. Is there a quick way to changes these manual
cells with out goining though each one?
 
=SUBSTITUTE(A1,"-","")in an adjacent cell and copied down will do it. Then just copy and paste
special as values.
 
If you wish to just change the display, select the cells
and press Ctrl+1, Number tab, Special, and choose SSN.
Otherwise, use a formula like:

=REPLACE(REPLACE(G1,4,,"-"),7,,"-")

HTH
Jason
Atlanta, GA
 
Back
Top