How to Format Phone Number - Google Sheets

Written by Tijana - Reviewed by Tanja Google Workplace / Sheets

4 min read

Although formatting phone numbers in Google Sheets is not a built-in function, it is possible with a bit of technical know-how.

You can format phone numbers in your spreadsheet using several different methods.

However, with a little bit of formula wizardry and some number formatting knowledge, you can complete this task with ease.

Applying the formatting is simple; the difficult part is choosing the appropriate format or formula.

In this article, we'll show you step-by-step all the tricks on how to format phone numbers in Google Sheets.

Related: How to Remove Gridlines in Google Sheets.

How do I change the unformatted phone numbers?

In this tutorial, the unformatted phone numbers will be changed to formatted using U.S. phone numbers, U.S. area codes, and country codes. You can change them to international codes by following the same steps.

Note: All phone numbers listed in this article were created using a fake phone number generator.

  1. Open the Google Sheet where you have entered your unformatted phone numbers. Highlight the column where you need to make the changes - i.e. column B.

format-phone-number2. In the top menu, click on 'Format'. The drop-down menu will open; click on 'Number'. From the 'Numbers' menu, click on 'Custom number format'.

google-sheets-format-number

  1. In the 'Custom number formats' field, enter the format formula you need, and click on 'Apply'. For example, for U.S. the phone number format is "(###)" "###"-"####".
  2. The custom formatting will be automatically applied to the selected range of cells.

formatted-phone-numbers

You might also find interesting: How to Color Every Other Row in Google Sheets and How to Add Subscript and Superscript in Google Sheets.

How to Write a Phone Number Format Formula

Depending on where you live - different phone number formats are used. Hence, the formula mentioned above wouldn't work for French phone numbers, per se.

Therefore, with the help of the following samples, you might be able to find the appropriate formatting. If not, they can offer a starting point that you can alter to fit the format you need.

  • Style: formula = example
  • US Style Domestic: “(“###”)”” “###”-“#### = (123) 456-7890
  • US Style Domestic with dashes: ###”-“###”-“#### = 123-456-7890
  • US International: “+1-”###”-“###”-“#### = +1-123-456-7890
  • Germany: “001-”###”-“###”-“#### = 001-123-456-7890
  • France: “191 “”###” “###” “#### = 191 123 456 7890

Additional notes

  • Depending on which format you want to use, you can add dashes, periods, prefixes, parenthesis, etc. to make suitable adjustments to your Google Sheet.
  • Sheets use double quotation marks to differentiate between text and numbers.

# - digit

"" - text

" " - adds space

"(" ")" - shows parentheses

"-" - adds a dash

"." - adds a period

"001" - adds predetermined numbers

"+1-" - adds a +1 international code, followed by a dash.

Conclusion

Even though there is no built-in function in Google Sheets that helps to format phone numbers with a single click, there are numerous options to create custom formulas that can ultimately help you get your phone numbers appropriately set.

If you liked this article, check out: How to Separate First and Last Name in Google Sheets.