How to Change the Number of Decimal Places in Excel – Knowligent
How to Change the Number of Decimal Places in Excel

How to Change the Number of Decimal Places in Excel

Home › How to, Tech › How to Change the Number of Decimal Places in Excel
Summary by Lifewire • Excel Tutorials by EasyClick Academy on Youtube • Published 18 years ago

This article explains how to change the number of decimal places in a Microsoft Excel spreadsheet. Instructions apply to Excel 2019, 2016, 2013, 2010, and 2007; Excel for Mac 2016 and 2011; Excel for the web; Excel for Microsoft 365 and Excel for Microsoft 365 for Mac; and Excel Mobile.

How to Change the Number of Decimal Places in Excel (Two Most Common Ways)

For numbers you have already entered in a worksheet, you can increase or decrease the number of decimal places displayed using the buttons on the toolbar.

Open Excel in your current worksheet

Select the cells you want to format.