Thread: HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789
Yeah, taking out the dashes makes a lot more sense that keeping the
numbers.
If you need it in a formula:
=SUBSTITUTE(A1,"-","")

Reply With QuoteReply With Quote