How to convert text numbers in Excel to numbers

How to convert text numbers in Excel to numbers:

In Excel, the system treats a number preceded by a half-width single quote as text, and for some purposes, the user can format the number as text by using the cell command on the Format menu. However, now that we need to convert the number of text formats in the worksheet to numbers, the following methods can be tried.

1. Convert one cell at a time

On the Tools menu, click Options, and then click the Error Checking tab (make sure that the Allow background error checking and number as text check boxes are selected). Select any cell that has a green error indicator in the upper-left corner. Next to the cell, click the button that appears, and then click Convert to Number.

2. Conversion of the entire area at a time

In a blank cell, enter the number "1". Select the cell, and on the Edit menu, click Copy. Select the range of cells that you want to convert to be stored as text numbers. On the Edit menu, click Paste Selective. Under Operations, click Multiply. Click the OK button.

3. Processing of special financial figures

Some financial programs display negative values with a minus sign "-" on the right side of the value. To convert this text string to a numeric value, you must return all text string characters except the rightmost character (that is, the minus sign), then multiply by "-1". For example, if the value in cell A2 is "156-", then the formula "=left (A2,len (A2)-1) *-1" Converts the text to a numeric "-156" and then operates with the above method.