Best Jquery ,javascript, HTML5 CSS3 tutorial with jquery examples, php script , demos for beginners, web designers and web developers.

Jquery

Jquery Training

Jquery training blog

How to add phone numbers in Google Sheets and make it callable

Mobile view of web sites are increasing day by day.So you need to make phone numbers callable as more and more people would be accessing your site on their mobile devices. Phone numbers callable mean when anyone click the phone number on mobile phone , the dialer will launch on the mobile phone and start Continue Reading


Mobile view of web sites are increasing day by day.So you need to make phone numbers callable as more and more people would be accessing your site on their mobile devices.

Phone numbers callable mean when anyone click the phone number on mobile phone , the dialer will launch on the mobile phone and start dialing of the specified phone number.
Just like when you click on an email link, it start the email sending mail box or default mail program.

HOW TO MAKE PHONE NUMBERS CALLABLE

9000900900

In the above example we have added tel protocol in href link.

If you access the web page through the mobile device it will open the dialer on click the phone number with prefill phone number.
No need to copy and paste the phone number.

HOW TO ADD PHONE NUMBERS IN GOOGLE SHEET
In google it is an tricky approach to add phone number. Whenever we start writing '+' in google sheet cell it assumes it as formula.

So we have to write like ="+123000000" or '+123000000

see the below images for example

Using =”+123000000″

phone number callable

Using  ‘+123000000

Now we have added phone number to google sheet.

<b>HOW TO MAKE PHONE NUMBERS CALLABLE AND CLICKABLE IN GOOGLE SHEET</b>

You can create a regular hyperlink in the cell pointing to a website which in turn redirects to the actual telephone link.

 

 

 

So to make a phone number callable in google sheet use the following formula

<pre>=HYPERLINK(“https://ctrlq.org/call/”&A1; “Call our support team”)</pre>

Please follow and like us:






About the author

Joydeb Choudhury holds a Master's degree in Computer Application from I.G.N.O.U. After working as a web developer in various companies he has started bloging in 2016.

Recent Posts of blog

Downalod Free Php Scripts