Cell validating c
And while stripping all/most non-numeric characters may work well on the server side (especially if you are planning on passing these values to a dialer), you may not want to thrash the user's input during validation, particularly if you want them to make corrections in another field.
In this example, we restrict users to enter a whole number between 0 and 10.
Validation Results Result from is Possible Number() true Result from is Valid Number() true Formatting Results: E164 format 12345678901 Original format (234) 567-8901 ext. 123 Out-of-country format from CH 00 1 234-567-8901 ext.
Everything else is just for user's convenience to protect against some (but not all) typos and does not validate anything. 123 Out-of-country format from US 1 (234) 567-8901 ext.
Result: Note: to remove data validation from a cell, select the cell, on the Data tab, in the Data Tools group, click Data Validation, and then click Clear All.
On the contrary, the 555 prefix is reserved for fake-out phone numbers. :\(\s*([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9])\s*\)|([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))\s*(? -Adam My gut feeling is reinforced by the amount of replies to this topic - that there is a virtually infinite number of solutions to this problem, none of which are going to be elegant.