Four ways Excel converts text to numbers

Four ways Excel converts text to numbers

Method one, using the function error-checking tool, if the number is text format, there will be a small triangle in the upper left corner of Things, click on the cell, select a small square with an exclamation point, select "Convert to Number" to complete the batch conversion

Method Two, arithmetic, is to subtraction the text-type numbers, such as the conversion of C2, write the formula =c2*1, you can convert the text into numeric values.

Method three, carry on "lighten the operation", it is in fact also be arithmetic, just write some different, for example to C2 to convert, writes the formula =--C2, through the computation, can convert the text type number to the numerical value

Method Four, is an inadvertent discovery of the fast operation, the single column of data conversion, this method is absolutely fast and cool, the operation is very simple, select the column to be converted, press Alt+d, appear the following tips

Then press E, and the following Column dialog box appears

Finally, press F, you can finish, 1 seconds after the completion of the operation, the person at the top is the one that sees your screen flash, and then finds that the text turns into a value, which uses the feature of the default column data format as the "normal" feature, and the text-type number in place "cut" into a regular