In EXCEL tables, the number entered by default is numeric, and the leading 0 in the number doesn't work, so EXCEL tables will automatically remove the leading 0. If you need a number with a zero in front, you can enter it in the following ways:

Method 1:

1, select the cell with zero before the number;

2. Click the right mouse button and select "Cell Format" from the shortcut menu that pops up;

3. The cell format dialog box pops up, and text is selected at the classification place;

4. At this time, you can enter the leading number.

Method 2:

In the half-angle punctuation state, enter the leading character "'"first, and then enter the number with zero.