How to add 0 in front of numbers in Excel?

#How to add 0 in front of numbers in excel?

Steps:

#1. We insert a column on the side of the data column (if there is There is no need to insert columns if there are blank columns).

For example, if column B is now a blank column, then we will use column B to operate.

2. We select column B; then, enter: =0&A1 in the edit bar, and then press the CTRL Enter key.

#3. The corresponding result will be obtained in column B; the mouse is under other cell points.

#4. If the original data in column A still needs to be displayed normally, the operation will be completed at this point.

If the original data in column A is no longer needed, you can hide column A;

If you want to delete it without hiding it, you need to copy the data in column B and paste the numerical data in place. , remove the original formula; then delete column A.

5. After deleting column A, column B becomes column A. The operation is completed.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to add 0 in front of numbers in Excel?. For more information, please follow other related articles on the PHP Chinese website!