+ Reply to Thread
Results 1 to 6 of 6

Phone number formatting from 8 digits to 10 with spaces

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    Australia
    MS-Off Ver
    Excel 2011 - Mac
    Posts
    7

    Phone number formatting from 8 digits to 10 with spaces

    Hi All,

    I've got a column of 8 digit phone numbers I need help formatting. I need to add the following to the start of the number. (02)space and then a space after the 4th digit.

    Eg. 12345678 to change to (02) 1234 5678

    Any help would be appreciated.

    Cheers,
    Ray

  2. #2
    Valued Forum Contributor gjlindn's Avatar
    Join Date
    08-01-2011
    Location
    Dodgeville, WI
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    369

    Re: Phone number formatting from 8 digits to 10 with spaces

    Hello Ray. You could create a custom format. "(02) #### ####"
    To create a custom format right click a cell and choose format. Then select Custom. In the Type box just input the text above without the quotes and click OK. You should be able to use that format from then on.

    -Greg

  3. #3
    Registered User
    Join Date
    08-30-2009
    Location
    Anacortes Washingtion
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1

    Re: Phone number formatting from 8 digits to 10 with spaces

    Hi

    Highlight the cells you want to change the format of and using the Format > Custom option and put in "(02)" #### ####

    akoobra

  4. #4
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Phone number formatting from 8 digits to 10 with spaces

    select range and right click, choose format cell then custom format. Copy follwing in the Type

    "(02)" #### ####

    and ok
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  5. #5
    Registered User
    Join Date
    07-13-2011
    Location
    Australia
    MS-Off Ver
    Excel 2011 - Mac
    Posts
    7

    Re: Phone number formatting from 8 digits to 10 with spaces

    Thanks all! So easy, really appreciate everyones help.

  6. #6
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Phone number formatting from 8 digits to 10 with spaces

    Be aware that custom format does not change the underlying value, so if you need your data beginning with (02) for further analysis, you will have to use other methods

+ 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