How to set the ID card number format in excel cell format

Setting method: First open the excel table, use the right mouse button to select the cell; then select "Format Cells" in the pop-up right-click menu; finally select "Text" in the pop-up window and click "OK" ” button.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.

Open Excel and create a new blank workbook. By default, entering ID number numbers will turn into garbled characters.

Right-click the cell and open Format Cells.

Set format to text mode.

# Confirm the settings and the ID number will appear in WYSIWYG editing mode.

Related learning recommendations: excel tutorial

The above is the detailed content of How to set the ID card number format in excel cell format. For more information, please follow other related articles on the PHP Chinese website!