Home  >  Article  >  Software Tutorial  >  How to set up segmented display of mobile phone numbers in Excel

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

WBOY
WBOYforward
2024-04-25 11:52:56678browse

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.

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

2. Enter the content that needs to be set.

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

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

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

4. Then a settings window will pop up.

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

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.

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

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

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete