How to Stop Showing Decimal Places in Excel 2010

People use Microsoft Excel for a number of different reasons, so there are often times when something that is correct for one user is not correct for another.

One specific area of contention is the number of decimal places that you need to use for your numbers.

While two decimal places might be ideal for someone, others need to use far more decimal places or do not want to use any at all.

Fortunately, you can change the number of decimal places in Excel 2010, and even stop showing them all together.

Change the Number of Decimal Places in Excel 2010

Note that this article will specifically focus on not showing any decimal places at all. However, you can follow the same steps below to simply switch to a different number of decimal places as well.

Instead of setting the number of decimal places to “0”, enter the number of decimal places that you want to show instead.

Step 1: Open your spreadsheet in Excel 2010.

Step 2: Use your mouse to highlight the cell(s) that contain(s) numbers for which you do not want to display any decimal places.

how to show zero decimal places in excel 2010

Step 3: Right-click one of the highlighted cells, then click the Format Cells option.

right-click, then select the format cells option

Step 4: Click inside the field to the right of Decimal Places, then change the number to 0.

change the number of decimal places to zero

Step 5: Click the OK button at the bottom of the window.

Now that you know how to stop showing decimal places in Excel 2010, you can restrict the display of cell values so that only the full number values are visible.

Note that you can also configure Excel to automatically show a number of decimal places. If you do a lot of data entry and don’t like to type decimal points, this can be helpful. Conversely, this is the setting that you need to change if Excel is automatically inserting a decimal place and you want it to stop that behavior.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy