Depending on how those phone numbers looked, I'd do a bunch of edit|replaces to
remove any non-numeric characters

Get rid of the ('s, )'s, (spaces), -'s and anything else you see.

Then apply a custom/special number format to the resulting digits.

essex711 wrote:

If I have a dataset of phone numbers in excel that are not all in the same
format, is there an easy way to have them reformatted so that they are all
consistent in that coulmn?

--

Dave Peterson