Because some of the data in the table does not have computational properties, it is a false “value” that cannot be involved in the calculation, so we need to find ways to turn them into real numbers. When doing Excel spreadsheet calculations, we sometimes find that some of the calculation results are incorrect, over and over again, and finally found that some data did not participate in the calculation according to our intention. In fact, these numbers appear to be numbers, but they are not numerical at all. So, how can we turn these digital formats that cannot participate in computing into true digital formats that can participate in computing? This has to be handled in three ways. Single or Adjacent Region Cells If you only convert numbers in one cell, or convert numbers in adjacent cell regions, you can use the following method. First click the “Microsoft Office button", then click “Excel Options” in the lower part of the pop-up menu. Next click on the "Formula" tab in the Excel Options window, then under “Error Check>, make sure the "Allow background error checking" checkbox is selected. Under "Error checking rules", make sure that the "number in text format or the number in front of the apostrophe" check box is selected. Click “OK" (Figure 1). On the worksheet, select any single cell with an error indicator in the upper left corner or an area of an adjacent cell. Note that all cells selected must be adjacent. Next to the selected cell or range of cells, click the error button that appears, and then click “Convert to Number”. If a non-adjacent area cell has this type of number in multiple non-adjacent cells or cell areas, how do you convert it at once? First, select a blank cell and verify its number format as “General”. To do this, in the "number" group on the "Start" tab, click the arrow next to the "number format" box, and then click “General”. Type 1 in this cell and press Enter. Select this cell, then click “Copy” in the “Clipboard” group on the “Start” tab (you can also press the keyboard shortcut Ctrl+C). Select the non-adjacent cell or range of cells that contain the number of text to be converted as text, and click the arrow under “Paste” in the "Clipboard> group on the “Start” tab And click “select paste”. Under "Operations", select “multiply”, then click “OK> (Figure 2). After all the numbers have been successfully converted, select the content typed in the temporary cell in the above step and press Delete to delete the temporary cell content. How to deal with the data after the symbol? In addition, there is a case where a negative negative number is displayed. When some financial programs display a negative value, the negative sign is located to the right of the value (such as 156-). Such a number is directly used to participate in the calculation and needs to be changed to a normal format (such as -156). To convert this text string into a numeric value that can be used to participate in the calculation, you must return all text string characters except the rightmost character (that is, the minus sign) and multiply the result by -1. For example, if the value in cell A2 is “156-”, the following formula converts the text to the value <;156” (Figure 3). =LEFT(A2, LEN(A2)-1)*(-1) This article is from [System Home] www.xp85.com