| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format from a list of numbers | Excel Discussion (Misc queries) | |||
| Format numbers returned in the function CONCATENATE | Excel Discussion (Misc queries) | |||
| Conditional format numbers | Excel Worksheet Functions | |||
| Is there a way to only format numbers that have digitsafter decima | Excel Discussion (Misc queries) | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
Linear Mode
