Benches Uncategorized

9

Changing phone number format in Numbers &…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Hi,

How do I change a column of phone numbers from 5035551212 to (503) 555-1212?

If I can't get the parenthesis, then at least to make it easier to read a phone number (e.g. spaces, dash).

Thanks,

Mark

9 replies

Sign in or join Beachball Help to reply.

  1. 0

    WWJD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You can format the cell as text and enter the parenthesis & spaces manually.

    Regards,

  2. 0

    marklovesportland

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    You're kidding, right?

    I am speaking of hundreds of numbers, in a column, that I want to "change" to an easier-to-read phone number format.

  3. 0

    5|=vv

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    If your phone numbers are in column A, for instance, you can create a new column populated (filled down) with a formula like:

    ="("&LEFT(A1,3)&") "&MID(A1,3,3)&"-"&RIGHT(A1,4)

    If you'd then rather not retain the old column A values, then select this new column and "Edit"/"Cut" and then select column A and "Edit"/"Paste Values".

  4. 0

    marklovesportland

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi,

    Thanks for the formula. I tried it, but noticed that my phone number "changes" one digit.

    ="("&LEFT(A1,3)&") "&MID(A1,3,3)&"-"&RIGHT(A1,4)

    for example, when I use (503) 555-1212, it changes to

    (503) 355-1212.

    I'm too new to Numbers to understand the formula, but this is definitely on the right track.

    Mark

  5. 0

    WWJD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Value to be parsed is in cell A3.

    Use:

    ="("&LEFT(A3,3)&") "&MID(A3,4,3)&"-"&RIGHT(A3,4)

    Regards,

    Look at Help for the MID function to get better understanding what the function does.

  6. 0

    5|=vv

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Sorry... there was a silly error in my formula that caused it to double up third digit. WWJD's formula has this corrected. I'm glad you caught it.

  7. 0

    marklovesportland

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi,

    Thank you both for your help, as this is PERFECT for me!

    Mark

  8. 0

    WWJD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Please send Feedback to Apple for expanded formatting for values (Telephone, Zip Code, etc...) You can find this on Numbers' main menu.

    Regards,

  9. 0

    Apple fan Michael

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    5|-vv,

    Nice tip. I wrote up a step by step, walk through for it on the blog. You can find it here:

    http://www.numberstemplates.com/2007/11/07/tip-formula-to-format-telephone-numbe rs/

    Thanks again,

    Michael