How to set up segmented display of mobile phone numbers in Excel

Worried about mobile phone numbers being displayed in scientific notation in Excel? PHP editor Apple brings a solution! This article will explain in detail how to display mobile phone numbers in segments to solve this common problem. From formatting cells to using formulas, we guide you through it step by step. Read on to keep your cell phone numbers neat and beautiful in your Excel spreadsheet!

1. Create a new Excel table.

2. Enter the content that needs to be set.

3. Select the cell that needs to be set, right-click the mouse and select [Format Cells].

4. Then a settings window will pop up.

5. Then select [Custom], enter [000-0000-0000] in the type of the style that needs to be segmented, and then click the [OK] button to set up.

6. The effect is as shown in the figure, the number has been displayed in segments.

The above is the detailed content of How to set up segmented display of mobile phone numbers in Excel. For more information, please follow other related articles on the PHP Chinese website!