View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LeeE LeeE is offline
external usenet poster
 
Posts: 2
Default Format a Telephone number

I want to format the telephone numbers in my excel file so that all look like
this:
508-567-3992 Eg: ###-###-####
Some have parenthesis around the first 3 digits, some have periods after the
3 digits.
I tried creating a custom type in numbers but I think it needs to be a
formula.

Can anyone help?

Thanks
Lee