The ROUND function below rounds a number to two decimal places. Useful FunctionsĮxcel offers several useful functions to change the number of decimal places of a number.ġ. Note: Excel stores the exact values of numbers, even if you can't see all the decimal places (except when you're using functions to change the number of decimal places, which we will see next). On the Home tab, in the Number group, click the Increase Decimal button six times. Note: these numbers look like integers (whole numbers).Ģ. For example, select the range B1:B5 below. To show more decimal places, use the Increase Decimal button in Excel.ġ. Note: if you want to use 2.2 to get a result of 6.6, round the value in cell A1. We can still use this underlying precise value in calculations. Note: if you look at the formula bar, you can see that cell A1 still contains the value 2.175.ģ. On the Home tab, in the Number group, click the Decrease Decimal button twice.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |