format cell with multiple formats for telephone numbers

N

Noe

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]##(###) ###-####;<9999999999>99999](###) ###-####

Help...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting phone numbers in contacts? 8
change ten digits in a cell to include phone # formats 5
Bulk editing of phone numbers in Excel 1
telephone number formating/formats 1
data extraction / cleansing a string column in a workbook 3
Problems with cell formatting 1
Unable to search for telephone numbers in Contacts... 2
In Excel, I want to have all telephone numbers display in the sam. 7

Top