Data Preparation

Note:The column 'purchase quantity' The value in this column is a text number

Only numbers in numeric format can be calculated, and numbers in text cannot be calculated

Sum the column 'purchase quantity', the result is an error, return 0 after carriage return

In view of the above problems, we need to convert the textual numbers in this column into numerical format to perform the summation operation, the method is as follows

1.VALUE function conversion method

Create a new column as an auxiliary column (column F) to store the converted values, enter =VALUE(D2)

Press the Enter key after entering the formula, you can see the converted numerical results, place the mouse in the lower right corner of the F2 cell, when the cross sign appears, double-click to complete the entire column of formula filling

You can use the SUM function to check whether to change to numeric mode

2. Multiply text numbers by 1 or add or subtract 0

With the help of the auxiliary cell F2, enter the number 1, then copy the cell where 1 is located (F2), select the number area in column D, then right-click the mouse, select the [Paste Special] command, and select [Multiply] in the operation method.], and then click the [OK] button

The final rendering result is shown below

You can use the SUM function to test whether to change to numeric mode

Supplement 1:The operation of adding 0 or subtracting 0 to a text-type number is the same as above, and readers can operate it by themselves

Supplement 2:Another similar method is to select any blank cell, copy, then select the data range, click the mouseRight-click, select [Paste Special], select [Add] in the operation method, and then click the [OK] button

3. Use the column function

First select the data area, and then select the [Columns] function of the [Data] tab

The "Text Column Wizard" pane pops up, click OK in steps 1 and 2, and step 3 is shown below

The final rendering result is shown below

Note:This function is only suitable for processing single-column data.And the format of this column must be clean, and cannot have a messy relationship with other columns such as merged cells

4. Convert directly to digital function

After selecting the data area, click the warning mark in the upper left corner and click the [Convert to Number] command.

The final rendering result is shown below

Note:This function requires the first cell in the upper left corner of the data areaThe cell data must be a text value. If the cell is not a text value, after selecting the range, Excel will no longer provide the function of [Convert to Number]

5. Copy and paste

Copy the data area, then open the clipboard under the [Start] tab, and click the relevant item in the clipboard.

The final rendering result is shown below