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 don't see any extra characters.  I formatted the cells with parens as numbers but no joy.  I 1,700 records to reformat to ###-###-####.

Answer 3

if you have a column of Phone Numbers then select the Column Header (A, B, C, D and so on)  then, apply the formatting as explained. 

__________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.

Answer 4

I did select the entire column nothing reformats.

I selecte individual cells and none reformats.

Very strange.

Answer 5

I notice that in your last screenshot is properly formatted, according to what you want.

can you click the cell correctly formatted? Then open the one below that is?  and tell what the difference is.

You might try clicking into cell formatted correctly. The double-click on it to select format and stay lock then drag down, until the last item, then click again when finished.  should change the format.

__________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Volunteer Moderator.