The numbers are store as numbers. Right now they are 999-999-9999 and I need
them to appear as (999) 999-9999. I tried what you recommended but I wasn't
able to pull it off.

Alan

"Harlan Grove" wrote:

Alan wrote...
I have an Excel list of phone numbers that I need to add parenthesis around
the area code. Anyone know how to do this? The list is about 3,000 numbers.

Are these phone numbers stored as numbers or as text, and do you just
need them to appear as (###) ###-#### ? If they're numbers and you just
need them to appear with area codes in parentheses, you could do that
with the custom number format

[=10000000](#) 000-0000;000-0000

If your phone numbers are stored as text, how are they formatted?