|
|
#2
03-03-2020, 10:39 AM
|
|||
|
|||
You would use a "picture switch."
\# "(###)-###-####" Field Switches and Pictures That will handle the phone number but not the +1. If possible use a helper column in your Excel to strip that out and use that helper column as your data source. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reliable way to convert text to number with a formula | levraininjaneer | Excel | 8 | 12-22-2019 04:47 PM |
| Attendance table Text Value Convert to Number | NickFazer | Excel | 2 | 11-08-2018 01:29 AM |
 Cannot Convert Text Cell to number format to be able to sort the data
|
jyfuller | Excel | 10 | 06-19-2013 05:31 PM |
|
Extracting a phone number from a string that contains text and numbers.
|
hommi16 | Excel | 2 | 06-05-2013 09:19 PM |
| Convert Number to Text | devcon | Word | 0 | 07-10-2010 01:16 AM |
Windows 10 
Office 2019
Threaded Mode