In an Excel cell, the first number 0 is not displayed. What should I do?

1. In EXCEL, select the excel cell to be processed, right-click, and select set cell format, as shown in the following figure;

2. Click "text" in the left-side selection box under "number" in "set cell format" and then click "OK;

3. The setting is successful. The number 0 can be displayed.

Well, no matter how long the number is entered, it also solves another problem. If the number is too long, it will automatically display scientific computing.