Multiple formats in one cell

[MikeTi]

Hi,
I am trying to figure out how to have multiple phone number formats i
one cell. For example;
I enter 9 digits into cell A1 for a U.S. phone number or 10 digits for
European phone number. I would like cell A1 to format the cell as +
(123) 456-7891 for 9 digits and + 12 34 567 8910 for 10 digits. Is thi
possible to do without creating multiple cells? Your help is greatl
appreciated

 

[Ron Rosenfeld]

Hi,
I am trying to figure out how to have multiple phone number formats in
one cell. For example;
I enter 9 digits into cell A1 for a U.S. phone number or 10 digits for a
European phone number. I would like cell A1 to format the cell as +1
(123) 456-7891 for 9 digits and + 12 34 567 8910 for 10 digits. Is this
possible to do without creating multiple cells? Your help is greatly
appreciated.

1. Note that US numbers have ten digits, and your European number example has 11 digits, although others have more.
2. So long as the first digit is not a zero, you can use the following custom format to differentially format numbers with 10 digits or less, vs those with more than 10 digits:

Format/Cells/Number/Custom Type: [<=9999999999]"+1 ("000) 000-0000;[>9999999999]+ 00 00 000 0000