Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell with multiple formats for telephone numbers
I have axla that I want to format telephone numbers in different formats.
#1 - 5 digit local PBX extension #2 - normal 10 digit telephone with area code (123) 456-7890 #3 - 12 digit out-dialed number in our PBX; e.g. - 81 (123) 456-7890 I tried using multiple "conditions" but I am stuck on how to formal all of the above combinations... Currently I have this as a "condition" : [<99999]#####;[9999999999]##(###) ###-#### but I can't quite multiple conditions to work. I tried this, but it threw an ERROR - [<99999]#####;[9999999999]##(###) ###-####;<999999999999999](###) ###-#### Help... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell with multiple formats for telephone numbers
try this
[<=9999999]###-####;### (###) ###-#### On Oct 21, 9:20*pm, Noe wrote: I have axla that I want to format telephone numbers in different formats. #1 - 5 digit local PBX extension #2 - normal 10 digit telephone with area code (123) 456-7890 #3 - 12 digit out-dialed number in our PBX; e.g. - 81 (123) 456-7890 I tried using multiple "conditions" but I am stuck on how to formal all of the above combinations... Currently I have this as a "condition" : [<99999]#####;[9999999999]##(###) ###-#### but I can't quite multiple conditions to work. I tried this, but it threw an ERROR - [<99999]#####;[9999999999]##(###) ###-####;<999999999999999](###) ###-#### Help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting telephone numbers to csv format! | Excel Discussion (Misc queries) | |||
Can I format telephone numbers? | Excel Worksheet Functions | |||
Format Telephone Cell Range | Excel Worksheet Functions | |||
how do i format telephone numbers | Excel Discussion (Misc queries) | |||
Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) |