What should I do if 0 at the beginning of the data in an Excel table is not displayed?

The problem status is as follows:

When we import the data in the text into the excel file, you will find that the previous 0 values in the figure below disappear, as shown in the following figure.

Solution:

Click "get external data" on the "data" tab in the excel table-"self-text" as shown in the following figure;

Then, find the file to be operated and click the "import" menu, as shown in the following figure;

Then, in the pop-up import wizard, click the "separator" and then check the "comma" check box, and then click the "next" step as shown in the figure;

Then, we can find the steps to set "column data format" to "text" as follows;

Now the leading zero is displayed normally.

Well, if you directly enter 0 in front of the number, we can right-click the cell and click "text format" in the right format attribute, as shown below.