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