spreadsheets Hub

How Text Fields Help You Keep Connected

Ever tried saving a phone number only to find its formatting changed? When you need to keep important contact numbers handy, preserving them exactly as entered makes them easier to recognize and use.

The Real Question

Have you ever wondered: Should phone numbers be stored as numbers? How can I keep parentheses, spaces, and plus signs intact? What's the easiest way to maintain a list of important phone numbers?

What you're really asking is: How can I preserve phone numbers exactly as I enter them?

Answer Sheets

Google Sheets Plain Text formatting preserves phone numbers as written, including parentheses, spaces, hyphens, and leading plus signs.

And here's what that looks like for me when I keep emergency household contact numbers together in a single column in my Contacts tab:

Emergency Household Contact Numbers
(302) 555-0101
(302) 555-0102
(302) 555-0103
1. Enter a heading in cell A1.

2. Select the cells or column intended for phone numbers.

3. Choose Format > Number > Plain Text.

4. Enter one phone number per cell beneath the heading.

5. Add new phone numbers in the next available cell.

Now I have a convenient list of household contact numbers that retain their original formatting and are easy to copy whenever I need them.

Keep Your Text Connections Close

  • Caregiver Managers. Keep important care-related contact numbers accessible.
  • Consultants. Preserve client telephone numbers in their original format.
  • Freelancers. Maintain customer contact numbers for future communication.
  • Household Managers. Keep emergency service numbers together.
  • Solo/Micro Landlords. Maintain a list of maintenance contractor phone numbers.
  • Travelers. Preserve accommodation and transportation contact numbers.

← Back to the spreadsheets Hub