How to convert the ID number into text?

Open the EXCEL form and paste the copied ID number, and the number mantissa will become 000. Select the cell where you want to paste the ID number, right-click and select the cell format. In the pop-up window, click Text on the left, click Paste in the upper left corner, and select the Match Target Format icon from the drop-down box. The ID number in the cell will be automatically converted to text format and displayed completely.

Tools/raw materials:

Mechanical Revolution S3 Pro

Windows 10

Excel 202 12 108

1, paste the number

Open the EXCEL form and paste the copied ID number, and the number mantissa will become 000.

2. Right click

Select the cell where you want to paste the ID number, right-click and select the cell format.

3. Set the text format

Pop-up window, click "Text" on the left.

Step 4 match the format

Click Paste in the upper left corner and select the Match Target Format icon from the drop-down box. The ID number in the cell will be automatically converted to text format and displayed completely.