| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Phone Numbers in Excel 2007 Help
I have phone numbers in two different formats:
1. 1-123-456-7890 (11 digits w/dashes) 2. 1234567890 (10 digits only) How can I convert the first format into the standard format in excel for phone numbers of (###) ###-####? I know the second format will do it automatically. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting phone numbers | Excel Discussion (Misc queries) | |||
| Formatting phone numbers using Special or Custom ..Help!!!! | Excel Discussion (Misc queries) | |||
| automatic formatting phone numbers in excel | Excel Worksheet Functions | |||
| Formatting Phone Numbers with Periods | Excel Discussion (Misc queries) | |||
| When merging phone numbers do not keep formatting why? | Excel Worksheet Functions | |||
Threaded Mode
