Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem With Phone Number Formatting? (e2k (9.0.6926 SP-3))

    I opened a Excel file that was exported from Access as

    File name: F:AppsAccess2klqrShawMailingList2008
    Save as type: Microsoft Excel 97-2000 (*.xls)

    Iím trying to format the phone column

    Phone
    1112224444

    Iím trying for format the Phone column as Phone Number and Iím not getting the following desired formatting:

    Using Select Phone column
    Click Format, CellsÖ, Special, Phone Number

    However if I type in a new phone number I get the formatting
    (111) 222-4444


    John

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem With Phone Number Formatting? (e2k (9.

    Check you original formatting. I'm guessing it's text and not a number. You have to set the formatting and then edit the cell to change it to the phone number formatting.

    You could highlight all of the newly formatted cells, open the immediate window in VBA and run:
    Selection.Value = Selection.Value

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem With Phone Number Formatting? (e2k (9.

    After further review they were all text fields '1112224444

    Selection.Value = Selection.Value changed the column to numeric

    Then the Select Phone column
    Click Format, CellsÖ, Special, Phone Number

    worked as designed

    Thanks, John

Posting Permissions

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