+ Reply to Thread
Results 1 to 3 of 3

Phone Format PHYSICAL

  1. #1
    RTP
    Guest

    Phone Format PHYSICAL

    I have a phone number coming in. I know I can change the format but I also
    need to PHYSICALLY change the cell as well. The cell HAS to appear as...

    (123)456-7890

    It HAS to because I have to try and De-Dupe it through Access and run an
    Unmatched query against it so that it attempts to match up correctly to the
    physical table wich is formatted as (123)456-7890.

    Can someone help me out here???

    Thanks!

  2. #2
    Ken Wright
    Guest

    Re: Phone Format PHYSICAL

    How does the data come in, is it just 1234567890? If so then assuming your
    data is in Col A and starting in A1, in b1 try

    =TEXT(A1,"(000)000-0000")

    Copy down, then copy all and paste special as values.

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :-)
    ----------------------------------------------------------------------------

    "RTP" <RTP@discussions.microsoft.com> wrote in message
    news:139E465B-C8DF-4A03-AD41-6AA780589EDA@microsoft.com...
    > I have a phone number coming in. I know I can change the format but I also
    > need to PHYSICALLY change the cell as well. The cell HAS to appear as...
    >
    > (123)456-7890
    >
    > It HAS to because I have to try and De-Dupe it through Access and run an
    > Unmatched query against it so that it attempts to match up correctly to

    the
    > physical table wich is formatted as (123)456-7890.
    >
    > Can someone help me out here???
    >
    > Thanks!




  3. #3
    Forum Contributor
    Join Date
    01-11-2004
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    388
    Hi!

    If the number comes in as 1234567890, the format you want is (assuming this number is in A1 and is formatted as text):

    ="(" & left(A1,3) & ")" & mid(A1,4,3) & "-" & right(A1,4)

    This depends on there being exactly 10 digits in the original data.

    Alf

+ 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