View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default remove text with format code for phone numbers

Hi,

The format code you need is General if this is really a formatting issue.

Cheers,
Shane

"Jan" wrote:

What format code is needed to remove the "()", spaces and "-" from "(555)
555-5555" that would look like "5555555555" ?

also from "555 555-5555" into "5555555555"
and "555 555 5555" into "5555555555"