How Do I Format Phone Numbers???

[lrdave36]

This is driving me nuts. I have a phone number field that is not in phone number format.


Example - 3234526666

I want Excel to format it as - (323) 452-6666


I've tried right clicking on the cell - Format - Special - Phone Number, but nothing changes. Even in the sample, it does not show the parenthesis.

What am I missing here?

 

[foxup]

Hi lrdave36,

You can do it 2 ways:

1 - Right click on the column's letter header (example A), Choose format cells->special-> phone#-OK

2 - Right click on the column's letter header (example A), Choose format cells-> Custom-> in the 'Type' box add this "(###)###-####" (without quotes) and click OK

That will do it.

Let me know if it works for you.


Thanks,
FOXUP!

 

[judgeh59]

My 1st question would be is this a real number?...IE: is there a little check in the upper left of the cell?...if it is, that means it's a text playing like a number...convert it to a real number and try again on the formatting...I tried your number and the special formatting for phone number and it worked....I then converted to a text and tried and it did nothing...

HTH

Be Alert, America needs more lerts

 

[lrdave36]

Thanks for the replies.

I figured it out. My column was already using a concat function to combine two columns into one. I did a paste special - values into a new column. Converted text to number and now the format is working!

 

[judgeh59]

sweeeeeeet

Be Alert, America needs more lerts

 

[foxup]

Glad to hear it.