CUSTOM FORMATTING OF PHONE NUMBERS IN GOOGLE SHEETS

Custom Number Formatting allows you to make many different alterations to your spreadsheet. In this video we will look at how to format a 10 digit number into a visually appealing phone number.

[obocar]

Man, you make me felt like I found a million $$. I was trying to separate the numbers, each number by hand until I found your video. The video makes life a lot easier for me. Thanks.

[CarolynQui]

Yes! All the users had their own way of formatting. It was crazy!

[gwmiller]

FINALLY! Couldn't figure this out. You just saved me a TON of time. Thank you!

[arnellcarmichael]

Bruh you saved me hours! Thought I was going to need some fancy formula, but no sir! Thanks my guy!

[cindycallaghan]

Excellent how-to video understandable speaking voice and pace.

[searchbug]

Great demo Brian. Many of our clients need this information. Even though our bulk Phone Validator doesn't require proper phone number formatting, once the bulk phone validator is complete, our users may want to know this information. We may include a link to this video for those users. Thanks!

[crosses]

A LEGEND RESIDES HERE!!!
Thank you my friend.

[radmac]

This is SUPER helpful! Tysm for the how to video.

[JackPointPizzaria]

Excelent! You saved my time!! Subscribed!!

[StepFunnels]

thanks so much spent hours trying to figure this out

[Yakiraw]

How do I do this with numbers from 9-12 digit from different countries? please help

[ellahorne]

OMG THANK YOU...!! I knew there had to be a simply way to do this! Question? Is there a way to highlight the whole column (C) besides just scrolling down?

[cqjifih]

I know the question is 2 years old (or your easy solution was shared 2 years ago...) Nevertheless is it possible to introduce a similar format when using google forms - directly in the form rather than have to do it in the data collection sheets form... Thanks

[LINXX]

I’m trying to enable the number to be callable for users while using sheets on phone Any suggestions?

[nidcmkc]

is that kind of format is good for CSV file?

[HARRYANDJACOBS]

Isit possible to make these numbers clickable and directed to phones for direct call?

[CarolynQui]

Hello, I need help. I created a form and it is working except when I share the form with my teammate for him to review the informaiton, he can't click on the "Responses". The options does not show. What did I do? Thanks

[centuriongamers]

Learned two things.
1.formatting i was searching for weeks
2.paint format which was always in front of me but never knew to use it

[FinalExpenseVirtual]

Thank you so much, this was very helpful

[mohammadbosphorus]

Thank you so much you solved my problem with this video