Open the excel as shown in the picture sales formulas are added in the amount column which are converted in numerical values.
1 , selected from the need to be well the cell where the formula is converted to a numeric value is shown in the sales amount column (column F) in the figure.
2. Right-click in the selected area and select “Copy” in the right-click menu bar or directly press Ctrl+C to copy.
3. After copying the cell, continue to right-click in the copy area and select Paste Special in the right click menu bar.

4, the pop-up “Paste” dialog, “Paste” Select “value” or “value and a digital format” below, both optionally substituted one, as the FIG.
5. After the selection is complete, click OK to return to the Excel worksheet interface and view the results, as shown in the figure below.
6. Press the Enter key or the “Esc” key to exit the editing state, and then click any cell in the Sales Amount column, we can see that the previous formula is gone, all marked with the value of the calculation result (as shown in the figure below), and it is complete.
Related posts:
- How to Enable Drag Option in Excel This article presents a collection of simple and nifty Excel...
- How many columns in excel? Excel spreadsheet there are 1,048,576 rows and 16,384 columns in it. View...
- How to change lowercase to uppercase in excel 2010 shortcut key In Microsoft Excel and OpenOffice Calc you can use the functions UPPER...
- How to rotate text in word Microsoft Office is an office application that is used by almost...
- Insert Superscript Google Docs Before we learn how to insert Superscript in google, We...
- How to display data in table format in android We are going to explain how to digitize a data table...
- How To Add Subscript in Word We can add Subscripts using 4 ways in Word: Automatic...
- How to enable insert option in excel You are born. You insert a column. Brings the same...
- How to Type Subscript in Word Below are the step by step to make the Subscripts...
- How to recover unsaved word document 2007 Sometimes Word automatically closes because there is no time to...