Cloud Training (Online)




Decimal places in Microsoft Excel

This article shows you how to show fewer decimal places in Excel without changing the number using Formatting i.e rounding off the number without changing the values. This a simple task that can be performed by using Format options in Excel.

How to limit the decimal places to few places in Excel?

Perform the following steps to round off a decimal number.

  • Select a cell that has a decimal number in it.
Decimal places in Microsoft Excel
  • Right-click on the cell and select Format cells.
Decimal places in Microsoft Excel
  • When the Format Cells dialog box opens up go to Number  under the Number tab.
Decimal places in Microsoft Excel
  • Now in Decimal Places choose either enter the limit of the number of decimal places that you want to display or change the limit using the arrows that are given.
Decimal places in Microsoft Excel
  • After fixing the limit. Click on OK to save the changes.
Decimal places in Microsoft Excel

So this way you can set limits to the decimal number.