ExcelRoadMap.com

Automatically Format Phone Number Input in Cells

Version: Microsoft 365
Last update:
Tip: Use ⬆️ ⬇️ to turn the page up and down. We recommend browsing with a large screen for a better reading experience.

1. Automatic Conversion of Pure Numeric Input

Automatically converts pure numeric input into the specified telephone number format.
Automatic Conversion of Pure Numeric Input

2. Open Format Cells

Hover your mouse over the cell where you want to input, right-click, and select Format Cells.
Open $$_Format Cells_$$

3. Set Format

Select Category as Custom, then enter the format: (000) 000 0000. Click OK to save.
Set Format

4. Try Entering Pure Numbers

For example, enter the number: 5553211234.
Try Entering Pure Numbers

5. Press Enter

The magic happens! You will see the number automatically change to: (555) 321 1234.
Press Enter

6. 🎉 Finish! 🎉

Author's Note: I hope you can feel the effort I put into these tutorials. I hope to create a series of very easy-to-understand Excel tutorials.

If it is useful, help me share these tutorials, thank you!


Follow me:

Related Tutorials

  • Automatically Format Phone Number Input in Cells
  • How to Enter Multiple Lines of Content in an Excel Cell
  • Use Focus Cell to Highlight Specific Cells
  • Excel Clipboard Tutorial
  • Auto Adjusting Cell Width and Height (AutoFit) in Excel
  • Use Flash Fill to Extract Emails from Text
  • Common Regular Expressions for Excel Users
    • Automatic Conversion of Pure Numeric Input