Thank you this was so helpful amnd time saving.


"John Bundy" wrote:

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
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"ApyoTech" wrote:

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