WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • cut decimal places in excel

    17 results for cut decimal places in excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    17 results for cut decimal places in excel

    TEXT formula in WPS Spreadsheet

    TEXT formula in WPS Spreadsheet

    03:09

    TEXT formula in WPS Spreadsheet

    The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

    Spreadsheet 0.156 views
    How to apply accounting number format in WPS Spreadsheet

    How to apply accounting number format in WPS Spreadsheet

    00:56

    How to apply accounting number format in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

    Spreadsheet views
    How to convert numbers into percentages

    How to convert numbers into percentages

    01:08

    How to convert numbers into percentages

    We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....

    Spreadsheet views
    Use the ROUND function to round decimals quickly 

    Use the ROUND function to round decimals quickly 

    01:57

    Use the ROUND function to round decimals quickly 

    In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

    Spreadsheet 0.1363 views
    How can we format cell values

    How can we format cell values

    01:57

    How can we format cell values

    Cell formatting is an important feature of spreadsheets. So today, we will briefly go through how to format cell values. Number formatting can be simply understood as a digital form that can be used for calculations.Take this table as an example: now the data in the cell is in text formatting. If using the SUM function to do calculations, we would find that the data in text format cannot be calculated. At this time, we need to convert the data into a number formatting that can support ....

    Spreadsheet 0.1484 views
    Data Format-Scientific Notation

    Data Format-Scientific Notation

    02:03

    Data Format-Scientific Notation

    In WPS Spreadsheet, scientific notation is normally applied to data so as to compute more digits yet save more spaces. Today we will introduce how to apply scientific notation format to data in cells.You can use the following methods:When entering large numbers, we can manually adjust the column width of the cells . By doing so, the number will display in scientific notation format automatically. In scientific notation, the power of 10 is generally expressed by E. For example, the numb....

    Spreadsheet views
    Create the double-layer doughnut chart

    Create the double-layer doughnut chart

    03:22

    Create the double-layer doughnut chart

    The double-layer doughnut chart can visually display the proportion of multiple data. As shown in the chart, this is the annual sales of a certain sales company. In this chart, we can see the proportion of sales per month and the sales percentage for each quarter. So how do we create the double-layer doughnut chart?First select the quarterly sales data in the cell range B2:B13, click the Insert tab and click the Insert Pie or Doughnut Chart drop-down button, then choose Doughnut in the....

    Spreadsheet views
    How to set the calculated field of the pivot table

    How to set the calculated field of the pivot table

    01:49

    How to set the calculated field of the pivot table

    We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

    Spreadsheet 0.1773 views
    Prev 123 Next
    WPS Academy
    Products
    Partners