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 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
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
see the below images for example
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>