automatic formatting phone numbers in excel

[Guest]

I am working on a project that rquires me to develop a phone list.

I need to know if there is a easy way to format the numbers and then have
the list automatically create the numbers in a sequential order. For example
I need automatically format all the numbers to read as (221) 843.
Then I would like to automatically generate the numbers. starting with the
numbers (221) 843-0001. In the next row then generated in a sequential order
the next number (221) 843 - ###2 all the way up to (221) 843-9999.

Thanks for any Assistant

 

[Guest]

Select an entire empty column, say B right click and format cells, select
custom at the bottom and select the last option. This option has two parts,
highlight and delete the first leaving just (###) ###-#### or just type it in
the box, now type the number in the first 2 boxes
2218430001
2218430002

then drag the bottom right corner down until you have what you need

 

[Guest]

One way to generate the numbers,

Put this in any starting cell:
="(221) 843-"&TEXT(ROW(A1),"0000")
Copy down by 9999 rows

 

[Guest]

Thank you this was so helpful amnd time saving.

Select an entire empty column, say B right click and format cells, select
custom at the bottom and select the last option. This option has two parts,
highlight and delete the first leaving just (###) ###-#### or just type it in
the box, now type the number in the first 2 boxes
2218430001
2218430002

then drag the bottom right corner down until you have what you need

 

[Guest]

Max,

This was a perfect soultion. Thank you so much.
LTA

 

[Max]

You're welcome. The feedback is appreciated.

 

[Guest]

Enter
2218430001
2218430002
drag the Fill Handle all the way down as far as needed

Format > Cells > Number tab > Special > slect Phone Number > OK