Thread: HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 TO 123456789
Edit replace - with nothing

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"doug@sunwest" wrote in message
...
HOW DO I CHANGE THE FORMAT OF A SS# FROM 123-45-6789 (text) TO 123456789
(number) in a cell ?


Reply With QuoteReply With Quote