Phone number with area code mask number format.

[eduzs]

I need to set a mask (cell number format) to do this:
Phone number can be with area code (lenght): 10 (2+8), 11 (2+9) or, without area code: 8 or 9. (non-us format)
Some aleatory (non real) numbers just for example:
12345678 result "1234-5678"
1212345678 result "(12) 1234-5678
123456789 result "12345-6789"
12123456789 result "(12) 12345-6789"
How can I do this?
Thanks

 

[Toadstool]

You can set individual Custom formats but if you have a column of these different number formats I can't see that working.

You could format them into another column with CHOOSE

	A	B
Phone	Phone Formatted
12345678	1234-5678
1212345678	(12) 1234-5678
123456789	12345-6789
12123456789	(12) 12345-6789

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=CHOOSE((LEN(A2)-7),TEXT(A2,"0000-0000"),TEXT(A2,"00000-0000"),TEXT(A2,"(00) 0000-0000"),TEXT(A2,"(00) 00000-0000"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Otherwise I think you'll have to use VBA. I'm sure a VBA expert will be along shortly.

 

[eduzs]

I will save this solution by formula, but the initial idea is just a "numberformat" mask.
Thanks