How to convert numbers into text in excel

How to convert numbers into text in Excel: First select the numbers that need to be converted, and click [Data-Column]; then select the delimiter and click Next; then proceed directly to the next step according to the default selection ;Finally, in the column data format, select [Text] and click Finish.

How to convert numbers into text in excel:

1. You can convert the numbers that need to be converted into text format Select all columns, then click the "Data" function in the menu, and then click "Sort Columns". (As shown in the picture below)

2. Enter the first step of the column sorting wizard, select the dividing symbol, and then proceed to the next step. (As shown below)

#3. When entering the second step, you can directly enter the next step according to the default selection. (As shown below)

4. Enter step 3 of the column sorting wizard. In the column data format, select "Text" and click Finish. (As shown below)

#5. In this way, the original number has been successfully converted into text format. (As shown below)

##Related learning recommendations:

excel basic tutorial

The above is the detailed content of How to convert numbers into text in excel. For more information, please follow other related articles on the PHP Chinese website!