Reformat phone numbers in Excel?

Hi Tim

I'm Abraham and I'd be happy to help you out with your question.

Please follow the steps on how to Apply Phone Number Formatting in Microsoft Excel

To start, open your spreadsheet with Microsoft Excel.

In your spreadsheet, select the cell or cells in which you have your phone numbers. To select all cell, you can click the column of the cell so that the custom rules apply to the column.

While your phone numbers are highlighted, in Excel’s ribbon at the top, click the “Home” tab.

On the “Home” tab, in the “Number” section, click “Number Format” (an arrow icon) at the bottom-right corner.

You will see a “Format Cells” window. Here, from the “Category” list on the left, select “Special.”

Select "Special" on the "Format Cells" window.

In the “Type” section on the right, click “Phone Number.” Then click “OK” at the bottom.

Note: If you don’t see “Phone Number” in the “Type” section, click the “Locale” drop-down menu and choose “English (United States)” or another supported country.

I hope this helps

Best Regards,

Abraham

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

I tried that. It didn't work at all.

Re: I don't understand.

Opoke's method would work if the original numbers were like... 1234567890

As for my formula; I assumed your data was in a single column starting in A2.

The formula would be entered into B2 and then automatically filled down to the bottom row

of the numbers.

The formulas would then be copied (the entire set of formulas in one copy operation)

and Values pasted in their place (in one operation).

Column A would be deleted, thereby turning Column B into Column A.

'---

Nothing Left to Lose

I dont understand.

Re: change phone number format

With 123-456-7890 in cell A2...

="("&REPLACE(A2,4,1,")")

Returns: (123)456-7890

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)