How to put decimals in Excel? In this tutorial we leave you all the steps and other details.
Surely, by now you must be aware that Excel is one of the most successful tools in the world to organize, categorize and create spreadsheets, not only because it has an incredible number of functions. But because within it, we can carry out any type of work and projects, without the need to be experts within the interface.
Also, you should know that within the same program we can do decimal operations, which are very useful for the fields of accounting and administration, whether for a job, business or simply as a university task. Within Excel we can put decimals, Without much effort.
Now, if you just find yourself getting to know and learning about the incredible benefits of Excel, in addition to all the functions that it contains, then we will make the task easier for you. teaching you how to put decimals in excel, as if you were a professional.
Ways to put decimals in Excel
In that we must tell you, that there are different methods, with which we can add decimal numbers to an excel sheet, those same methods, we detail them with their step by step. Which are the following:
Enter the formula in the corresponding column
This is the first way, which we will teach you to be able to enter decimals in an excel sheet, for this you must follow the instructions that we now leave you. They are the following:
- As a first step, you will need to open an Excel spreadsheet.
- Then you must enter the values of the rounded numbers, each one within an individual cell. As a recommendation, it is best to enter the numbers, all within the same column, that will make the method easier to perform.
- Within the second column, you must add the following formula “= round (A1,N)”. At that time, you must replace the "N" within the formula with the decimal number, which you want to add.
- For the following columns, it will not be necessary to rewrite the formula, since you can drag and drop it into the following cells, up to the last one you intend to use. You can also use the copy and paste options, when they are in the same column.
- Example: “=Round (A1,8)”
That's it! That way you will have learned first method to put decimals in excel.
Put decimals in Excel without formula
This is the Another known method enter decimals in excel, on the other hand, this does not require formulas to be able to work and for this, we also leave you the complete list of steps, which is as follows:
- First enter the decimal numeric values you want, in each cell.
- Then you must choose one or all.
- Next you will have to locate yourself within the “start” tab.
- Then, you must use the buttons to "reduce or increase" the number of selected cells by one digit. That way it will be ready.
Likewise, you could have put decimals in excel without using formula.
Put decimals in Excel using the Truncate function, for decimals without rounds
We must confess that the previous methods are based only on a more general approach, which allows us to increase or decrease the number, depending on whether its decimal is above or below 5.
In this method, the remaining decimal numbers will be eliminated automatically, regardless of the symmetrical rounding, for this we have the following steps:
- Inside an empty cell, we must write the following formula: “=TRUNCAR(A1;N)» supposing that the box A! is where the decimal number is and the "N" is the number of digits we want to see in the spreadsheet.
- Then we just have to press the "enter" key and that way we finish.
That's it, so we got another one how to put decimals in excel.
Round decimals in Excel. (Key points to consider)
You should know that the place decimals in excel, it does not become a complicated or difficult task, now to round these decimals, you can use all the methods that we left you with previously. The same ones you can use, if the lack of decimals is not a problem for you.
Also, you should know that the functions to round decimals within Excel are mostly dominated by a certain rule, in which we are told that if the last digit of the decimal number is greater than 5, the number increases. a 1. On the other hand, if that same number ends in a decimal with a value less than 5, then the base number remains, with its current value.
Other applications that allow us to do operations with decimals
In the incredible case that Excel may not be the program you were really looking for to perform your calculation operations with decimals, we leave you other alternatives, which you can use at the moment, to be able to put decimals. Those are the following:
1. Symbolab
This is an online calculator, where we can perform all kinds of algebraic operations, from the simplest to the most complex.
This calculator can be used when accessing its web platform https://es.symbolab.com/solver/decimals-calculator, it's totally free and you can get a lot of amazing features.
In addition to being quite useful, when performing any addition, subtraction, multiplication or division of decimals, without the need to write down or save data, just for something of the moment.
2. DivPad: Math Step by Step
This, for its part, is an application available for the Android operating system, where you can perform all kinds of mathematical operations, including decimal operations, in a matter of minutes.
If you want to calculate or get an account, accurately and quickly, this mobile application is the one you should use.
3. Division calculator (with remainders or decimals)
This one, on the other hand, is also an application for the Android operating system, which is totally free and interactive, with the only peculiarity that it focuses clearly on solving operations with decimals.
So if you constantly have to calculate using decimals, this application is the one you should choose.