New
#1
Excel not responding. Trying to format a column of phone numbers.
Excel 2010
I have a column of 22,000 phone numbers (and an additional column of fax numbers).
I'm trying to convert the numbers from nine digits to nine digits with hyphens.
I copied and renamed the original document. There are no protections.
To be certain, I ran the Doc Inspector. I'm still free to do anything to the list.
The instructions are easy:
Highlight column, select Format cell, click Custom, in Type, insert XXX-XXX-XXXX, click OK. That didn't work.
Next, instead of click Custom, I clicked Special, selected phone number, clicked OK.
Instead of hyphens, if it adds parentheses around the area code. I'm not that picky, although it takes more space.
That doesn't work either.
I am less than a novice in Excel when it comes to creating anything. I've managed to fill in others and not have to create my own.
The only thing that doesn't look like instructions is that the Sample above Type never changes.
I don't know if it should.
Thank you.