View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pete5440 pete5440 is offline
external usenet poster
 
Posts: 13
Default Formula to change Phone Number format

I have a large list of 10 digit phone numbers currently formatted as
1234567890. I would like to change them so area code and prefix is separated
by hyphen 123-456-7890. Is there a relatively simple way to do this with a
formula? Would having some of the numbers already changed to my desired
format affect how the formula runs?