1.    25 Aug 2016 #1
    Join Date : Feb 2016
    Posts : 100
    Microsoft Windows 10 Home 64-bit 10586 Multiprocessor Free

    Excel not responding. Trying to format a column of phone numbers.


    Excel 2010
    I have a column of 22,000 phone numbers (and an additional column of fax numbers).
    I'm trying to convert the numbers from nine digits to nine digits with hyphens.

    I copied and renamed the original document. There are no protections.
    To be certain, I ran the Doc Inspector. I'm still free to do anything to the list.

    The instructions are easy:
    Highlight column, select Format cell, click Custom, in Type, insert XXX-XXX-XXXX, click OK. That didn't work.
    Next, instead of click Custom, I clicked Special, selected phone number, clicked OK.
    Instead of hyphens, if it adds parentheses around the area code. I'm not that picky, although it takes more space.
    That doesn't work either.

    I am less than a novice in Excel when it comes to creating anything. I've managed to fill in others and not have to create my own.

    The only thing that doesn't look like instructions is that the Sample above Type never changes.
    I don't know if it should.

    Click image for larger version. 

Name:	Excel FWS.jpg 
Views:	22 
Size:	87.7 KB 
ID:	98191

    Thank you.
      My ComputerSystem Spec
  2.    26 Aug 2016 #2
    Join Date : Nov 2015
    Posts : 138
    W10

    Highlight column, select Format cell, click Custom, in Type, insert XXX-XXX-XXXX, click OK. That didn't work

    Excel 2003: Try: ####0-##0-###0
    Be sure to start with number format.
      My ComputerSystem Spec
  3.    26 Aug 2016 #3
    Join Date : Feb 2016
    Posts : 100
    Microsoft Windows 10 Home 64-bit 10586 Multiprocessor Free
    Thread Starter

    PiKo,

    I have Excel 2010, but I am sure that doesn't make an ounce of difference.
    Your suggestion does not work, either.
    There is no other option but formatting Number. Since you mentioned it, though, I looked at Protection. The default is "locked" so I unchecked it - just to test.
    I would think it's something simple, but can't guess.

    Thank you for your quick response.
      My ComputerSystem Spec
  4.    26 Aug 2016 #4
    Join Date : Nov 2015
    Posts : 138
    W10

    I did some experiments, but custom formatting in "Type" has always an immediate effect on "Sample" (and the cells).
    Also with me, Protection is Locked, but that has no influence.
    I suppose you tried this also on one cell instead of 22000 cells?
    And you tried it also in a new document?
    When it does not work in a new document either, maybe a repair action of Office is required.
    When it does work in a new document, the problem should be related to something in the telephone document.
    In the latter case, you may export all data and import these into a new document.
    I don't have any further ideas.
    Success!
      My ComputerSystem Spec
  5.    26 Aug 2016 #5
    Join Date : Oct 2013
    Posts : 335
    Windows 10 Pro x64, Windows 7 Ultimate x64 SP1, Windows 8.1 Pro x64

    In Excel 2010 when you select Custom in format cells, Type In ###-###-#### where it says type. This will create a custom format.
      My ComputerSystem Spec
  6.    26 Aug 2016 #6
    Join Date : Feb 2016
    Posts : 100
    Microsoft Windows 10 Home 64-bit 10586 Multiprocessor Free
    Thread Starter

    PiKo,

    Logic prevailed for the first three. Starting at the fourth:
    No, of course, I didn't try it in a different doc, until a moment ago.
    As you said, the sample immediately changed.
    It worked like a charm.

    Having done this, I am certain your export/import suggestion will as well.
    With certain programs and in certain situations, I know where the blame lies.
    As an avid Excel avoider, I hadn't a clue.
    Success - you nailed it!

    Thank you.
      My ComputerSystem Spec
  7.    27 Aug 2016 #7
    Join Date : Feb 2016
    Posts : 100
    Microsoft Windows 10 Home 64-bit 10586 Multiprocessor Free
    Thread Starter

    pbcopter,

    See post - #1 - I tried that and failed.
    It wasn't the formula, per se; that particular column or the doc itself is somehow flawed or corrupted.
    PiKo had me try it in another sheet, so I did.
    It took a second to prove his/her theory.

    Nothing succeeds like success!

    Thank you.
      My ComputerSystem Spec

 


Similar Threads
Thread Forum
Numbers Keypad opens apps as well as typing numbers
I'm talking about the keypad at the right end of the keyboard. When I press some number keys, apps open; if I use the numbers at the top of the keyboard, they work as usual. I can't find this specific issue anywhere online. 94679 1 opens...
General Support
Solved Cloning HDD to SSD-HDD is 512 format & SSD is 4096 format. Matter?
If so, what are my options? This HDD came from HP w/Win 7. I upgraded it to Win 10 but would like to clone it to the SSD for the speed increase. Thanks in advance, jeff
Installation and Upgrade
Solved Column Bar problems.
I'm having a problem with the Column Bar in File Explorer. I like to show Backup Method in my backup folders along with Name, Date, etc. When I first installed Windows 10 it wasn't available in the drop down so I didn't think too much about it, but...
General Support
How to make executable & linkable file with phone numbers.
I have seen people sending executable & linkable file with phone numbers in Whatapp which after clicking automatically ask us to add to contacts. How these files are created and what is the software name? Please help. Thanks Ashok
Software and Apps
Solved How do i get rid of extra column in Folders
can someone please advise how I can get rid of this37243
General Support
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 15:34.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums