Make cells recognise phone numbers when you copy paste a phone number into a cell
Make cells recognise phone numbers when you copy paste a phone number into a cell. ALways have to add an " before the phone number.................
A.C. Wilson commented
Difficult, because different countries have different conventions for punctuating the components of phone numbers. Even in Canada-Carribean-USA region, multiple variations exist, even though this particular region shares one common 10-digit convention (e.g., "(999) 999-9999"; "999-999-999 9", "999.999.9999"; "1-800-999-9999" ).