Formatting phone numbers using Special or Custom ..Help!!!!

H

HopeFromMS

In Excel Worksheet, Using <format><cells><special><phonenumbers> I get
(2) 228-8964, NOT (123) 456-6789. I want to enter phone numbers with area
code and not have to enter dashes or parantheses. Why is it not working??!!!
You can see it is leaving only one number in the area code parantheses.
 
D

Dave O

If you'll right click on the cell or cells in question, select Format
Cells, then Custom. Copy the text string below into your Clipboard,
then paste it into the Type textbox that appears in that window.

[<=9999999]###-####;(###) ###-####

Does that solve the problem?

Dave O
Eschew obfuscation
 
H

HopeFromMS

Dave:
I did as you said, which was the same text string that I had. It still only
allows 1 digit in the parantheses and thusly drops the last two digits of the
phone number. I cannot understand why.
 

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

Similar Threads

format phone numbers with an 800 2
Formatting Phone Numbers in Excel 2007 Help 16
custom inputs 1
Format appears stuck..how to break formatting 2
Formatting phone numbers in contacts? 8
Function to uniformerly format different phone numbers 7
change ten digits in a cell to include phone # formats 5
Formatting Phone Numbers with Periods 3

Top