+ Reply to Thread
Results 1 to 5 of 5

Format for Phone Number - Won't work

  1. #1
    Registered User
    Join Date
    09-16-2012
    Location
    Phoenix, AZ, USA
    MS-Off Ver
    Excel 2010
    Posts
    38

    Format for Phone Number - Won't work

    I cannot format a group of cells for "phone". If I double click a cell, then click on the cell below it, the phone formatting occurs. But it will not format more than one cell at a time. My data (see below) will format for phone (see first cell) if only I double click the cell then click on the cell blow it.

    How can I get a large group of cells to format for phone without double clicking them one by one?

    (480) 710-9912
    6026807108
    6024002844
    6027416841
    6029420446
    6027890400
    4805605449

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Format for Phone Number - Won't work

    I got it to format just fine...
    R
    7
    (602) 680-7108
    8
    (602) 400-2844
    9
    (602) 741-6841
    10
    (602) 942-0446
    11
    (602) 789-0400
    12
    (480) 560-5449


    rt click/Format/Special/Phone Number
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    09-16-2012
    Location
    Phoenix, AZ, USA
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Format for Phone Number - Won't work

    Ah ha! Your response got me to approach it from another direction. The cells first have to be converted to "number" format then they would format for phone. Apparently, the data I had stored them as text. Once I converted to number they formatted correctly. Thank you very much!

  4. #4
    Registered User
    Join Date
    09-16-2012
    Location
    Phoenix, AZ, USA
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Format for Phone Number - Won't work

    OK ... how do I mark this as solved?

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,602

    Re: Format for Phone Number - Won't work

    Please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Phone number format - reference post (Formatting Textbox to type phone numbers only)
    By eddyrcabrera79 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2015, 05:35 PM
  2. [SOLVED] Extract Following Format Phone Number
    By Mohanmoni in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-20-2015, 12:47 PM
  3. Change Phone number format
    By genefalk1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-26-2014, 10:43 PM
  4. Format a Phone Number
    By scotfitz in forum Excel General
    Replies: 4
    Last Post: 12-23-2009, 07:01 PM
  5. phone number format question
    By bonz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2006, 02:51 AM
  6. How to format a phone number in Excel
    By tfanatik in forum Excel General
    Replies: 4
    Last Post: 05-12-2006, 12:00 PM
  7. how do I add phone number format as a permanent custom format?
    By frustratedagain in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 11:52 PM

Tags for this Thread

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