#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!