The Phone data type is for phone numbers. You can format phone numbers as links that open your default voice calling application, and can adjust for different country phone number formatting. Phone data types are particularly useful when on mobile, as you can call directly from your worksheet.
The Phone data type can facilitate calling from Spreadsheet.com. Or use the Phone data type to store contact information of job candidates, sales leads, or registrants for that product keynote you have coming up.
Note: Spreadsheet.com does not check the veracity of entered phone numbers. You may want to check all phone numbers to ensure they are correct.
Data in Phone Cells
Setting a column to the Phone data type will convert all existing numbers into phone numbers. After you have set a column, cell, or range of cells to a Phone data type you can type or paste in the desired number. Phone numbers can even be clickable links that open your default phone app to make the call.
Phone data types are particularly handy when you open worksheets on mobile. To call, simply navigate to the desired phone number, tap, and select call.
Like other data types, Phone data types can have Strict enabled. Selecting the Strict checkbox for Phone cells will restrict users to input only numeric characters, and will either empty cells that are not phone numbers or turn all text entered into a phone number. Also, columns that have Strict enabled cannot have cells of different data types.
The format drop-down in the Phone data type dialog box allows you to see how entered phone numbers will look. Also, if your selected country has multiple possible formatting options, you can choose from them here.
Spreadsheet.com, like other sites, defaults phone numbers (tel: links) to a blue color. You can change this and other settings in the formatting toolbar at the top of your worksheet.
By default, Spreadsheet.com sets the phone country to match the country of the worksheet's creator. You can change this for a column, cell, or range of cells, formatting phone numbers for other countries differently. To change, simply select from twenty-five country options in the country drop-down.
Spreadsheet.com also has data types for URLs, Email addresses, or to add and work with Users directly in your worksheet. Check out those or other data types for unique ways to collect contact information and work with users.