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
1	Phone	Phone Formatted
2	12345678	1234-5678
3	1212345678	(12) 1234-5678
4	123456789	12345-6789
5	12123456789	(12) 12345-6789

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B2 =CHOOSE((LEN(A2)-7),TEXT(A2,"0000-0000"),TEXT(A2,"00000-0000"),TEXT(A2,"(00) 0000-0000"),TEXT(A2,"(00) 00000-0000")) <tbody> </tbody>

<tbody>
</tbody>

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