The main reason for these problems is that Excel may recognize certain numbers when importing files created in other programs or importing files downloaded from the network. For text, this will cause some functions in the Excel table (such as SUM and AVERAGE) to ignore the values in those cells. We need to find ways to turn them into mathematical numbers that can really participate in the calculations. Many times, the data we need to process in Excel comes from a network or other data management system. When we import data from these channels into an Excel spreadsheet, we often find errors in the calculation results. How to avoid this happening? How do you convert the transferred data into a digital format that can participate in the calculation? 1. Prepare the previous unified settings "General" format If you are not sure which format of the transferred data, the format is not unified, you can first set the number format in all unrecognizable cells to "ld"; The regular & rdquo; format to deal with, and then use the various methods we will talk about below. Take Excel 2013 as an example. After selecting the range of cells to be set, select “Format" in the "cell" >; group" in the "cell" Cell format & rdquo; one (Figure 1). In the Formatting window that pops up, under the "Number" tab, click "General" under "Classification" and then click “OK> (Figure 2). 2. Auto Error Correction On Error Check Button If there are error indicators in the upper left corner of the cell that displays the number as text, click the cell that contains the error indicator, then click the error button next to the cell, and then click “Convert to a number” The above method is based on the case where the background error checking function in Excel is turned on. If error checking is not turned on in Excel, you need to turn it on before you can use this method to convert the number format. The specific method is as follows. Click “Options" on the "File" menu to open the Excel Options Settings window. Click on the left side of the "Formula" option. Under the "Error check" option group on the right side, click to select the "Allow background error check" check box and set the color to identify the error. Then select all the check boxes under the “Error Check Rule” group (see Figure 3) and click “OK”. 3. Manual Error Correction Retype Cell Values For individual cells that have errors, you can also manually retype the value of the cell using manual error correction. To retype a value in a cell, follow these steps. In the “Start” tab page, select “Group">;"Format" in the drop-down menu and select “Set Cell Format" In the "Digital" tab, select “value", "value", "currency", "accounting" "%", "score", "score" "scientific count" Wait for the number format (Figure 4), then retype the number. 4. Direct Editing Set editing permissions in advance. We can also edit directly in the cell in question. However, you need to open the edit permission settings in the Excel editing option settings in advance. Click “Options" on the "File" menu. In the "Advanced & Rarr; Edit Options" column, make sure the "Allow editing directly in cells" checkbox is selected, click “OK" (Figure 5). After that, double-click the cell you want to format, press Enter and press Enter. 5. Refresh the format Using “Selective Paste The digital format error, the main reason is to use the original format in the data transfer process. In order to avoid the interference of the original format, we can use the "optional paste" to clone the type of the number into the "value" class. First type the number 1 in any empty cell of the Excel table, select the cell, and then click the &Copyquo> Select the range of cells in which you want to convert the values to numbers. Under the &startquo;Clipboard →Paste” menu, click “Select Paste " (Figure 6). In the "Select Paste" window that pops up, select the "Value" group under the "Paste" group; under the "Operation" group, click Select "Multiply". Then click “OK" (Figure 7). Finally, delete the cell that was previously transitional and has a value of 1. Tip: Some data management systems place a negative sign to the right of the value when displaying a negative value. To convert such copied text strings into numeric values, you must intercept all numeric characters from the text string, filter out the rightmost negative sign, and multiply the result by –1. For example, if the value in cell A8 is 1890-, you can use the following formula to convert the text to a value – 1890:=-1*LEFT(A8, LEN(A8)-1) This article is from [System Home] Www.xp85.com