What should I do if the ID card number cannot be displayed in excel?

Because the ID card number is 18 characters and excel only shows 15 characters, the last three digits are changed to 0. How to display the correct ID card number in excel?

I have summarized two methods:

Method 1

Right-click the column that displays the ID card and choose "set cell format"-"text" from the shortcut menu. Copy and paste the document in the txt file.

Method 2

Select Data-self-text, select the file to be imported, select the separator, select the column data format, select the ID column, select text, and click finish, in this way, the normal ID card number is displayed.