FORMATING PHONE NUMBER!!

J

jay dean

In Range("H2") is a 10-digit number. How do I format the cell to show
the number in the format ###-###-####. Example: Entering 1478942266
should convert to 147-894-2266.

Any help would be appreciated!
Jay

*** Sent via Developersdex http://www.developersdex.com ***
 
R

Rick Rothstein

Select Format/Cells from Excel's menu bar, select the Number tab on the
dialog box that comes up, select Custom from the Category list and then put
this into the Type field...

000-000-0000
 
J

Jacob Skaria

Select the column or the cells. Right click-->Format Cells--> Custom..Type
text box enter the below

###-###-####


If this post helps click Yes
 
J

Jacob Skaria

If you are looking for VBA use FORMAT

Msgbox Format("1234567890","###-###-####")

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top