Excel 2010: How To Decrease/Increase Decimal Places

In Excel 2010, you can set (increase/decrease) decimal places according to the required spreadsheet pattern. It provides you with two ways in which you can change the decimal places. Lets take a look at how to increase/decrease the decimal places.

For changing decimal places i.e increase/decrease decimal points, select the cell, column or row in which you need to change it, navigate to Home tab and from Numbers group, click on respective option.


47d1273427643-how-decrease-increase-decimal-places-

It will change the decimal place in the selected cell(s) as specified.

46d1273427641-how-decrease-increase-decimal-places-

Advertisement