automatic formatting phone numbers in excel
 

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

automatic formatting phone numbers in excel
 

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

automatic formatting phone numbers in excel
 

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

automatic formatting phone numbers in excel
 

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

automatic formatting phone numbers in excel
 

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

automatic formatting phone numbers in excel
 

You're welcome. The feedback is appreciated.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ApyoTech" wrote in message
...
Max,

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

automatic formatting phone numbers in excel
 

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

Format Cells Number tab Special slect Phone Number OK



"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