How to add dashes in contact phone number in excel ?

Asked By sherrydlongo 50 points N/A Posted on - 11/15/2012

I have received detail of my clients in excel sheet, and their phone numbers are in unformatted form (ex: 1231231234) in excel sheet,I want data in formatted (ex: 123-123-1234 ) form. My query is how to add dashes in contact phone number??

• Status: Open
• Question Views: 1396
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sinky Kramer

Go To Solution

Best Answer

Best Answer

Answered By Sinky Kramer 0 points N/A #140704

How to add dashes in contact phone number in excel ?

Good day! Here is a simple solution for you.

On your excel spread sheet:

1. Highlight all the numbers you want to be formatted.

2. Right click and click on "Format Cells"

3. Under the "numbers" tab, you will see "custom" Click on it.

4. After clicking Custom, you will be able to see "type:" and a text box below it. 

5. Type this code in it: _(#-####-#0_)

6. Click OK

7. You will be able to see the numbers are now formatted in this form 1111-1111-11

 

Thanks!

About Sinky Kramer

Questions
4

Answers
34

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 11/15/2012
• Question Category: MS Excel

Answered By Alexander Nelson 10 points N/A #140705

How to add dashes in contact phone number in excel ?

Adding dashes (-) in phone numbers on excel sheet is easy. Just select the column on which the phone numbers are located. Then right click on it and then “Format cells”. Click on “Custom” and type ###-###-#### and finally click ok. You are done.
You may use formula too. If your first number is in C1, put this in D1 and copy down:
=LEFT(C1,3)&"-"&MID(C1,4,3)&"-"&RIGHT(C1,4) .

About Alexander Nelson

Questions
1

Answers
57

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 11/15/2012
• Question Category: MS Excel