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.
