Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Telephone number
You could use something like:
[Blue](000)_-000-0000 as a custom format. I like the blue because it makes it easier to spot the failures :) Note that this format will not like ANY non-digit characters (including hypens). On Nov 3, 5:49*pm, LeeE wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a Telephone number
Here is one way...
=TEXT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE( SUBSTITUTE(A1," ",""),")",""),"(",""),".",""),"-",""),"000-000-0000") Hope this helps, Hutch "LeeE" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
telephone number format | Excel Discussion (Misc queries) | |||
How do I format to telephone number | Excel Discussion (Misc queries) | |||
telephone number format change in Excel | Excel Worksheet Functions | |||
custom telephone number format | Excel Discussion (Misc queries) | |||
Telephone number format | Excel Discussion (Misc queries) |