Thread: How do I format a social security number to have no dashes?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
  
Posts: 284
Default How do I format a social security number to have no dashes?
I have a column in Excel with social security numbers and i need to make the
formatting so the number has no dashes in it. So for instance 111-11-1111,
should look like 11111111. Is there a quick way to format my column to look
like this??

Thanks

Kim
Reply With QuoteReply With Quote