Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Global format change (Excel 2k)

    I've inherited an old spreadsheet that has phone and fax numbers entered 0000000000 as opposed to (000)000-0000. I've set the custom format and selected the columns (without the headers) to apply the format and it won't update. If I delete the phone number and re-enter it, it appears with the parens and the hyphen. Also if I use the format painter I can change them cell by cell, but I'm not able to do it globally. I know I've done this before, but it's been a while since I've used excel, and I can't figure it out!

    <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Global format change (Excel 2k)

    Perhaps the phone and fax numbers are interpreted as text. Try the following:
    1. Select an empty cell.
    2. Copy it to the clipboard (Edit | Copy or Ctrl+C)
    3. Select the cells with phone/fax numbers.
    4. Select Edit | Paste Special...
    5. Click Add, then OK.
    6. Set the custom phone number format.

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Global format change (Excel 2k)

    If the Format Painter works, then simply uses the Format Painter to highlight the entire Column or Row - by clicking on "H" or "5" - whichever the case may be. HTH
    Gre

  4. #4
    3 Star Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Global format change (Excel 2k)

    Thanks Hans, worked like a charm.

Posting Permissions

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