Reformatting Phone Numbers in Numbers

If you have a list of phone numbers in a Numbers spreadsheet, you may find that they use a variety of different formats and you'd rather have them all in one format. You can do this one time using search and replace, then cell formatting to get the numbers to look the way you want. Or, you can use a long nested formula to remove all unwanted characters and then the same cell formatting.

Comments: 6 Responses to “Reformatting Phone Numbers in Numbers”

    Christopher
    2 years ago

    Hello,

    I enjoy your videos. This one makes me glad I store all my numbers in contacts!

    Eric
    2 years ago

    Thank you for posting this.

    Nello
    2 years ago

    Hello,

    here Numbers 3.6.2 El Capitain 10.11.6, pasting the formula from text edit, but the cell didn’t formatting, any advice?

    Thanks

    2 years ago

    Nello: Not sure what you mean by “the cell didn’t formatting” — what did you try, exactly, and what do the results look like, exactly? Did you enter it as a formula, or maybe paste it in as text by mistake? Make sure you type a = to enter the formula entry mode first, then paste in the formula.

    Nello
    2 years ago

    Sorry i was putting one parenthesis in excess at the end of the formula, now everything works.

    Eric
    2 years ago

    Yet another useful video from Gary.

    Unfortunately, the example of entering a new phone number and having it automatically reformatted was off-screen in the video.

Comments Closed.