Reformat telephone numbers in a column so all are formatted the s.
 

How do I reformat a column of telephone numbers so that all appear the same -
no parenthesis only the ###-###-####. I don't want to have to retype each
number.
--
Maree

Reformat telephone numbers in a column so all are formatted the s.
 

If your current numbers are all the same length and all need to be the same
structure try using something like this in an empyty column
=LEFT(A1,3)&"-"&MID(A1,4,3)&"-"&RIGHT(A1,4) The LEFT function takes the 1st
3, the MID function takes the next 3 starting at character 4 and the RIGHT
function takes the last 4 from the right. The "-" gives you the separator
character.
Replace A1 with your own cell reference and then copy to all other numbers
Hope this helps

Sheila

"Maree" wrote:

How do I reformat a column of telephone numbers so that all appear the same -
no parenthesis only the ###-###-####. I don't want to have to retype each
number.
--
Maree

Reformat telephone numbers in a column so all are formatted the s.
 

Hi Maree. You can format the column so that all phone numbers appear as
(123) 456-7890 by selecting the cells, going to format - cells - special and
selecting phone number.
--
Sincerely, Michael Colvin


"Maree" wrote:

How do I reformat a column of telephone numbers so that all appear the same -
no parenthesis only the ###-###-####. I don't want to have to retype each
number.
--
Maree