+ Reply to Thread
Results 1 to 5 of 5

change ten digits in a cell to include phone # formats

  1. #1
    Judi Mason
    Guest

    change ten digits in a cell to include phone # formats

    I need to change a cell with ten digits to include the phone number format
    characters. Not just in the "view", but in the actual cell. The cell needs
    to be changed from "1234567890" to "(123) 456-7890", including the space
    after the area code. I am importing an excel file of phone numbers and the
    contents need to be exact. Any suggestions?

  2. #2
    Gary Rowe
    Guest

    RE: change ten digits in a cell to include phone # formats

    Assuming your number is in cell A1, enter the following formula in cell b1:
    =TEXT(A1,"(000) 000-0000"), copy that formula to for other lines and then
    copy/paste values and the result will be the text you're looking for.
    Gary

    "Judi Mason" wrote:

    > I need to change a cell with ten digits to include the phone number format
    > characters. Not just in the "view", but in the actual cell. The cell needs
    > to be changed from "1234567890" to "(123) 456-7890", including the space
    > after the area code. I am importing an excel file of phone numbers and the
    > contents need to be exact. Any suggestions?


  3. #3
    RagDyer
    Guest

    Re: change ten digits in a cell to include phone # formats

    Have you tried,
    <Format> <Cells> <Number> tab,
    And click on "Special", and choose "Phone Number"
    ?
    --
    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================



    "Judi Mason" <Judi [email protected]> wrote in message
    news:[email protected]...
    > I need to change a cell with ten digits to include the phone number format
    > characters. Not just in the "view", but in the actual cell. The cell

    needs
    > to be changed from "1234567890" to "(123) 456-7890", including the space
    > after the area code. I am importing an excel file of phone numbers and

    the
    > contents need to be exact. Any suggestions?



  4. #4
    CLR
    Guest

    Re: change ten digits in a cell to include phone # formats

    ="("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4)

    Vaya con Dios,
    Chuck, CABGx3


    "Judi Mason" <Judi [email protected]> wrote in message
    news:[email protected]...
    > I need to change a cell with ten digits to include the phone number format
    > characters. Not just in the "view", but in the actual cell. The cell

    needs
    > to be changed from "1234567890" to "(123) 456-7890", including the space
    > after the area code. I am importing an excel file of phone numbers and

    the
    > contents need to be exact. Any suggestions?




  5. #5
    CLR
    Guest

    Re: change ten digits in a cell to include phone # formats

    Sorry, forgot to mention that if you use this formula and then do Copy >
    PasteSpecial > Values, then you will get all the info in the cell without
    just being "formatted", as you asked.............

    Vaya con Dios,
    Chuck, CABGx3


    "CLR" <[email protected]> wrote in message
    news:[email protected]...
    > ="("&LEFT(A1,3)&") "&MID(A1,4,3)&"-"&RIGHT(A1,4)
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    > "Judi Mason" <Judi [email protected]> wrote in message
    > news:[email protected]...
    > > I need to change a cell with ten digits to include the phone number

    format
    > > characters. Not just in the "view", but in the actual cell. The cell

    > needs
    > > to be changed from "1234567890" to "(123) 456-7890", including the space
    > > after the area code. I am importing an excel file of phone numbers and

    > the
    > > contents need to be exact. Any suggestions?

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1