I have a phone number field: formatted as (text) ,
that keeps getting jumbled with many variations of entries.
One exception: on international phone calls:
(XXX) 6980-XXXX this is correct
final result should be:
for International numbers
VBA code is great if can be supplied.