ExcelBanter - format cell with multiple formats for telephone numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - format cell with multiple formats for telephone numbers (https://www.excelbanter.com/excel-discussion-misc-queries/207208-format-cell-multiple-formats-telephone-numbers.html)

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...

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...