Useful tips for Excel cell formatting

In Excel tables, there are a lot of tricks that we don't know or don't use, and working with tables is the most common gadget for us to learn and work with. Excel tools are mainly used in WPS and Office software, we can use any of them to open the table, learning and constantly practice Excel to speed up our work efficiency.

Use one: Segment display mobile phone number

1, we open Excel input name and mobile phone number (this demo is false), and then all selected mobile phone number part, I am here "b1-b4" area. Then we can open the cell formatting interface by clicking the triangle arrow in the lower-right corner of the Font tab of the Start menu.

2, open cell format there are two of the most common, one is all the selected areas right-click to select Format cells, and the second is the small arrow in the lower-right corner of the "Number" tab in the Start menu, and you can open the cell format and manipulate the number interface.

3, we click on the "Number" screen to select "Custom", and then we enter the "type" inside the format of the 000-0000-0000, is our mobile phone number of 11-digit display format. Enter the completion of the click "OK" on it, let's take a look at the effect of the diagram below ~

Usage Two: The data is displayed in million units

1, the number of display we are using any one of the above to open the cell, I am here directly using the shortcut keys or right click on the "Format cell formatting" Open, and then in the "digital" interface. To open a cell formatting shortcut key: ctrl+1

2, then, we choose the "custom" digital mode, in the right type inside the input 0!. 0, "million" (Pinyin input status), click "OK" after we can see the effect of the ~

Note:

The cell formatting of Excel uses tips to help us do different digital display modes.