Format sequence for phone numbers?
 

I can't figure out what the "text" format of a telephone number is.

If cell A1 contains the text "Telephone"
and cell A2 = (213) 555-1234
(I've formatted cell A2 with FormatCellSpecialPhone Number so that
it always appears in this format).

I have an output cell with the following formula:

=A1&": "&A2

and I get this:

Telephone: 2135551234

so then I tried to modify my formula to this:

=A1&": "&TEXT(A2,??)

But I don't know what to put where the question marks are.

This should be really simple but I just don't know.

Can someone help?

Thanks.


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=547280

Format sequence for phone numbers?
 

A2 actually contains: 2135551234, but it's formatted to look nice.

You could try:
=A1&": "&TEXT(A2,"(000) 000-0000")

or if there's a chance that a2 contains a 7 digit number:
=A1&": "&TEXT(A2,"[<=9999999]000-0000;(000) 000-0000")

LACA wrote:

I can't figure out what the "text" format of a telephone number is.

If cell A1 contains the text "Telephone"
and cell A2 = (213) 555-1234
(I've formatted cell A2 with FormatCellSpecialPhone Number so that
it always appears in this format).

I have an output cell with the following formula:

=A1&": "&A2

and I get this:

Telephone: 2135551234

so then I tried to modify my formula to this:

=A1&": "&TEXT(A2,??)

But I don't know what to put where the question marks are.

This should be really simple but I just don't know.

Can someone help?

Thanks.

--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=547280

--

Dave Peterson

Format sequence for phone numbers?
 

Thank you!


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=547280