How to enter 001 in excel: first open an excel table; then right-click to set the cell format; then click [Text] in the cell format; finally enter "001" in the text box.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.
1. Open an excel table. Here is a blank excel table as an example.
2. When you enter "001" in the table, it will The first two 0s are missing
#3. Before entering "001" in the table, right-click to set the cell format and click [Text]
4. Enter "001" in the text box, and then "001" will appear
5. There is another The first method is to add [']
The above is the detailed content of How to enter 001 in excel. For more information, please follow other related articles on the PHP Chinese website!