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