Max,

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

"Max" wrote:

One way to generate the numbers,

Put this in any starting cell:
="(221) 843-"&TEXT(ROW(A1),"0000")
Copy down by 9999 rows
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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