How to convert text format to numeric format

Method to convert text format to numerical format: First select the data column whose format needs to be converted, click [Column] on the [Data] tab [Data Tools] group; then in the pop-up [Text In the Sorting Wizard window, click Next to complete.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Methods to convert text format into numerical format:

1. Use the [Column] method to quickly convert text format into data format.

Open excel and select the data column to be converted.

2. On the [Data] tab [Data Tools] group, click [Column]

3. In the pop-up "Text Column Wizard" window, go to fool mode and click Next. Default settings, press Next, Next, Next.

4. After completion, you will find that the original small triangle is gone and the text Numbers have been converted to numeric format.

Related learning recommendations: excel tutorial

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