How do I create a phone number format with only dashes and numbers

Question

I am trying to create a phone number format with only numbers and dashes.  I have a file with phone numbers formatted as (###) ###-####.  I want to reformat to ###-###-####.  I tried and the attached screen shot does not work.

Answer 1

This is so simple to do. No macros are needed.

In the column next to the column you want to format, enter the phone number in the desired format and press return. Then press Control-e to invoke Flash Fill. The column will fill with the proper formatting.

Answer 2

I did and nothing changes.  I

f I format an empty cell as ###-###-#### and manually type in the numbers, it formats correctly.  But I am unable to reformat a cell.

Answer 3

Jim,

If you can, share a sample workbook on onedrive.live.com

Bernie

Answer 4

OK - I am logged into OneDrive.  I don't see how to share my workbook.

Answer 5

Upload your file, then find it and click the radio button next to it.  The top menu will change to include a "Share" option. You will be able to then create a link, copy the link, and paste it in a message.