Formatting problem with telephone numbers in excel.

Hi Dale Lawrence

Hopefully I understand you right.

Not the most elegant solution (SergeiBaklan will probably have something much nicer) but I've created the following formula to hopefully achieve the format that you want:

=LEFT(A2,3)&LEN(A2)-8&LEN(A2)-7&LEN(A2)-6&RIGHT(A2,4) 

Place the code in the same row as the first cell and phone number, autofill downwards and that should convert all your numbers to this format. This assumes that your phone numbers are as you say in xxx-xxx-xxxx format.

Here's a sample spreadsheet for you to play with in regard to this formula.

Hope that helps with your desired solution!

Cheers

Damien