❖ How to Type Phone Numbers in a Google Sheet
It is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why:
Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon as add the plus sign in the spreadsheet cell, it assumes that you entering a math formula and tries to calculate the value.
There are two simple workarounds to this problem. You can enclose the phone number inside double quotes (“) and precede it with an equal to (=) sign.
An even easier alternative is to use the single quote (‘) before the phone number. Google Sheets will then interpret the cell’s value as text and the phone number formatting will be preserved
❖ How to Make Phone Numbers Clickable in Google Sheets
You can create a regular hyperlink in the cell pointing to a website which in turn redirects to the actual telephone link. To see this in action, add https://ctrlq.org/call/ before any phone number in the Google Sheet and it will turn into a clickable telephone link.
Say you have the phone number in cell A1. Add this simple formula in any other cell and it will create a telephone link just like on a regular webpage.
=HYPERLINK(“https://ctrlq.org/call/”&A1; “Call our support team”)
0 comments:
Post a Comment