View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Noe Noe is offline
external usenet poster
 
Posts: 20
Default 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...