L
LACA
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 Format>Cell>Special>Phone 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.
If cell A1 contains the text "Telephone"
and cell A2 = (213) 555-1234
(I've formatted cell A2 with Format>Cell>Special>Phone 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.