Good Morning,

I need assistance with converting phone numbers in an Excel spreadsheet.

Currently, the numbers all show up as "1234567890", but I need them to show up as "123-456-7890". I know that there's an option to convert the text to look like a phone number, but that's not what I need. Yes, it changes the appearance of the number in the cell, but I need the number to be changed in the cell when you click on it.

For example;

I have 1234567890 in cell 1A. In the function bar, it shows as 1234567890.



I can change the appearance to be (123) 456 - 7890, which is ok, however it just changes the appearance.

I need it to change it in the cell from 1234567890 to 123-456-7890.

I've tried format painter, find and replace, the only thing that I can think of to do at this point is go line by line and change it. My sheet has about 1000 numbers in it.

Help!!!