| 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) | |||
Linear Mode
