Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Set Decimal Places in Microsoft Excel

Date:2019-11-1 Author:Olivia

Numbers are displayed with no decimals by default in Excel, but some data need to be set decimal places as the work requirements. So how can we achieve it? The method is simple to follow:

1. Select the data which you want to set decimal places.

How to Set Decimal Places in Microsoft Excel

2. Go to Home tab, find Number group and click the arrow at bottom right.

How to Set Decimal Places in Microsoft Excel

3. The Format Cells dialog box will display, go to Number tab, then click Number under Category.

How to Set Decimal Places in Microsoft Excel

4. Now you can set decimal places in the box of Decimal places. Note: To increase is to click the up arrow, to reduce is to click the down arrow.

How to Set Decimal Places in Microsoft Excel

5. Simply click OK to save the settings, then the data will be modified accordingly.

How to Set Decimal Places in Microsoft Excel

How to Set Decimal Places in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *