How to enter 001 in excel

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 [']

####################################################################### ”############### Recommended: "###Excel Tutorial###"###

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!